explain-analyze.info | query-plan-1187

Query Plan as raw text

Summary

Time		Node
Node (ms)	Percent	Node
0.090	100.00%	¶	`Nested Loop (cost=0.0..3.3 rows=1 width=26) (actual time=0.048..0.090 rows=2 loops=1) Join Filter: (ur.child_id = uc.id)`
0.043	47.78%	¶	`-> Nested Loop (cost=0.0..2.17 rows=1 width=21) (actual time=0.030..0.043 rows=2 loops=1) Join Filter: (up.id = ur.parent_id)`
0.019	21.11%	¶	`-> Seq Scan on test_user up (cost=0.0..1.08 rows=1 width=13) (actual time=0.016..0.019 rows=1 loops=1) Filter: ((name)::text = 'John'::text)`
0.007	7.78%	¶	`-> Seq Scan on test_reference ur (cost=0.0..1.04 rows=4 width=16) (actual time=0.003..0.007 rows=4 loops=1)`
0.016	17.78%	¶	`-> Seq Scan on test_user uc (cost=0.0..1.06 rows=6 width=13) (actual time=0.002..0.008 rows=6 loops=2)`

Run-time

0.174 ms

Highlighted rows indicate a disparity between the number of rows estimated and actually returned. You may want to run ANALYZE to update the server's statistics.
For more information on using EXPLAIN and interpreting its output, see the Postgres documentation, in particular the EXPLAIN and ANALYZE references pages, and Using Explain.