explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HBcP

Settings
# exclusive inclusive rows x rows loops node
1. 1.263 491.342 ↓ 1,864.0 1,864 1

Nested Loop (cost=32,257.89..32,297.61 rows=1 width=268) (actual time=4.707..491.342 rows=1,864 loops=1)

  • -> Index Scan using dse_13535_new_grib_meta_data_datetime_validity_datetime on grib_message_meta_data (cost=0.57..32249.02 rows=1,487 width=94) (actual time=0.025..323.897 rows=482
  • Index Cond: ((two >= 'lima'::timestamp with time zone) AND (two <= 'quebec_lima'::timestamp with time zone) AND (india
  • Filter: (delta_charlie = 'romeo'::text)
  • Rows Removed by Filter: 390,086
2. 50.935 488.215 ↓ 1,864.0 1,864 1

Hash Join (cost=8.59..42.24 rows=1 width=265) (actual time=4.694..488.215 rows=1,864 loops=1)

  • Hash Cond: (seven.papa = juliet.quebec_seven)
3. 432.655 432.655 ↓ 324.3 482,232 1

CTE Scan on seven (cost=0.00..29.74 rows=1,487 width=64) (actual time=0.027..432.655 rows=482,232 loops=1)

4. 1.309 4.625 ↓ 4,488.0 4,488 1

Hash (cost=8.58..8.58 rows=1 width=209) (actual time=4.625..4.625 rows=4,488 loops=1)

  • Buckets: 8,192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 1,485kB
5. 3.316 3.316 ↓ 4,488.0 4,488 1

Index Scan using alpha on mike juliet (cost=0.56..8.58 rows=1 width=209) (actual time=0.021..3.316 rows=4,488 loops=1)

  • Index Cond: ((tango = 'bravo'::text) AND (oscar = 'delta_victor'::text))
6. 1.864 1.864 ↑ 1.0 1 1,864

Index Scan using five on xray kilo (cost=0.28..6.36 rows=1 width=11) (actual time=0.001..0.001 rows=1 loops=1,864)

  • Index Cond: (quebec_seven = seven.hotel)
Planning time : 1.476 ms
Execution time : 514.440 ms