explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0k9u

Settings
# exclusive inclusive rows x rows loops node
1. 10.750 47.320 ↑ 1.0 41,301 1

Hash Join (cost=2,470.890..6,436.320 rows=41,301 width=595) (actual time=20.928..47.320 rows=41,301 loops=1)

  • Hash Cond: ((uniform.oscar)::text = (foxtrot.oscar)::text)
2. 15.950 15.950 ↑ 1.0 41,301 1

Seq Scan on golf uniform (cost=0.000..3,857.010 rows=41,301 width=595) (actual time=0.019..15.950 rows=41,301 loops=1)

  • Filter: yankee
3. 6.184 20.620 ↑ 1.0 41,305 1

Hash (cost=1,954.570..1,954.570 rows=41,305 width=37) (actual time=20.620..20.620 rows=41,305 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 3,296kB
4. 14.436 14.436 ↑ 1.0 41,305 1

Seq Scan on mike foxtrot (cost=0.000..1,954.570 rows=41,305 width=37) (actual time=0.015..14.436 rows=41,305 loops=1)

  • Filter: (((whiskey)::text = 'delta'::text) AND ((alpha)::text = 'xray'::text))
Planning time : 17.967 ms
Execution time : 48.653 ms