explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JHYP : test23

Settings
# exclusive inclusive rows x rows loops node
1. 163.724 263.949 ↓ 349.2 94,622 1

Sort (cost=13,418.060..13,418.730 rows=271 width=433) (actual time=219.523..263.949 rows=94,622 loops=1)

  • Sort Key: india_hotel.alpha
  • Sort Method: external merge Disk: 36184kB
2. 44.672 100.225 ↓ 349.2 94,622 1

Nested Loop (cost=0.430..13,407.100 rows=271 width=433) (actual time=0.386..100.225 rows=94,622 loops=1)

3. 0.674 0.674 ↑ 2.0 1 1

Seq Scan on xray (cost=0.000..162.210 rows=2 width=20) (actual time=0.372..0.674 rows=1 loops=1)

  • Filter: (zulu_lima = 4497)
  • Rows Removed by Filter: 4819
4. 54.879 54.879 ↓ 266.5 94,622 1

Index Scan using india_bravo on india_hotel (cost=0.430..6,618.900 rows=355 width=433) (actual time=0.010..54.879 rows=94,622 loops=1)

  • Index Cond: (hotel = xray.quebec_seven_victor)
  • Filter: ((yankee five NULL) AND (lima_sierra(xray.foxtrot, 'delta'::timestamp with time zone) <= quebec_seven_zulu) AND (lima_sierra(xray.lima_romeo, zulu_golf()) > quebec_seven_zulu))
  • Rows Removed by Filter: 10