explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AhVb

Settings
# exclusive inclusive rows x rows loops node
1. 563.637 40,939.689 ↑ 1,560.5 247 1

GroupAggregate (cost=835,229.05..121,594,535.96 rows=385,441 width=20) (actual time=33,911.425..40,939.689 rows=247 loops=1)

  • Group Key: ((romeo0.foxtrot_three)::date)
2. 565.329 34,038.268 ↓ 1.7 792,223 1

Sort (cost=835,229.05..836,410.35 rows=472,522 width=57) (actual time=33,891.534..34,038.268 rows=792,223 loops=1)

  • Sort Key: ((romeo0.foxtrot_three)::date)
  • Sort Method: external merge Disk: 59,248kB
3. 1,200.653 33,472.939 ↓ 1.7 792,223 1

Hash Join (cost=250,531.83..772,927.80 rows=472,522 width=57) (actual time=9,051.026..33,472.939 rows=792,223 loops=1)

  • Hash Cond: (romeo0.charlie_alpha = quebec_sierra1.quebec_seven)
4. 23,254.478 23,254.478 ↓ 1.3 792,818 1

Seq Scan on two six (cost=0.00..494,332.53 rows=621,767 width=65) (actual time=0.985..23,254.478 rows=792,818 loops=1)

  • Filter: ((zulu_lima five NOT NULL) AND (foxtrot_three >= 'charlie_sierra'::timestamp without time zone) AND (foxtrot_three <= zulu_golf()))
  • Rows Removed by Filter: 4,633,872
5. 541.524 9,017.808 ↑ 1.0 2,732,171 1

Hash (cost=205,693.70..205,693.70 rows=2,732,970 width=4) (actual time=9,017.808..9,017.808 rows=2,732,171 loops=1)

  • Buckets: 131,072 Batches: 64 Memory Usage: 2,529kB
6. 8,476.284 8,476.284 ↑ 1.0 2,732,171 1

Seq Scan on yankee foxtrot_four (cost=0.00..205,693.70 rows=2,732,970 width=4) (actual time=0.423..8,476.284 rows=2,732,171 loops=1)

7.          

SubPlan (for GroupAggregate)

8. 0.000 3,168.892 ↑ 1.0 1 792,223

Aggregate (cost=127.75..127.77 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=792,223)

9. 441.692 3,168.892 ↑ 100.0 1 792,223

Nested Loop (cost=0.01..127.00 rows=100 width=32) (actual time=0.003..0.004 rows=1 loops=792,223)

10. 1,584.446 1,584.446 ↑ 100.0 1 792,223

Function Scan on sierra_papa delta (cost=0.00..1.00 rows=100 width=32) (actual time=0.001..0.002 rows=1 loops=792,223)

11. 1,142.754 1,142.754 ↑ 1.0 1 571,377

Function Scan on whiskey alpha_three (cost=0.00..1.25 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=571,377)

  • Filter: (bravo = 'hotel'::text)
  • Rows Removed by Filter: 1
12. 0.000 3,168.892 ↑ 1.0 1 792,223

Aggregate (cost=127.75..127.77 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=792,223)

13. 441.692 3,168.892 ↑ 100.0 1 792,223

Nested Loop (cost=0.01..127.00 rows=100 width=32) (actual time=0.003..0.004 rows=1 loops=792,223)

14. 1,584.446 1,584.446 ↑ 100.0 1 792,223

Function Scan on sierra_papa alpha_six (cost=0.00..1.00 rows=100 width=32) (actual time=0.001..0.002 rows=1 loops=792,223)

15. 1,142.754 1,142.754 ↑ 1.0 1 571,377

Function Scan on whiskey sierra_tango (cost=0.00..1.25 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=571,377)

  • Filter: (bravo = 'victor'::text)
  • Rows Removed by Filter: 1
Planning time : 12.012 ms
Execution time : 40,948.692 ms