explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xyg4

Settings
# exclusive inclusive rows x rows loops node
1. 0.213 0.501 ↑ 6.7 12 1

Sort (cost=31.990..32.190 rows=80 width=1,112) (actual time=0.499..0.501 rows=12 loops=1)

  • Sort Key: (xray_yankee(yankee."tango", 'two'::text))
  • Sort Method: quicksort Memory: 27kB
2. 0.230 0.288 ↑ 6.7 12 1

Hash Right Join (cost=12.000..29.460 rows=80 width=1,112) (actual time=0.173..0.288 rows=12 loops=1)

  • Hash Cond: (((foxtrot."bravo")::text = (yankee."bravo")::text) AND ((foxtrot."romeo")::text = (yankee."romeo")::text))
3. 0.012 0.012 ↑ 150.0 2 1

Seq Scan on xray_delta foxtrot (cost=0.000..13.000 rows=300 width=244) (actual time=0.011..0.012 rows=2 loops=1)

4. 0.024 0.046 ↑ 6.7 12 1

Hash (cost=10.800..10.800 rows=80 width=918) (actual time=0.046..0.046 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
5. 0.022 0.022 ↑ 6.7 12 1

Seq Scan on whiskey yankee (cost=0.000..10.800 rows=80 width=918) (actual time=0.018..0.022 rows=12 loops=1)

Planning time : 0.727 ms