explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C7Qs

Settings
# exclusive inclusive rows x rows loops node
1. 0.257 7,925.441 ↓ 1.9 144 1

Sort (cost=23,412.670..23,412.860 rows=76 width=12) (actual time=7,925.426..7,925.441 rows=144 loops=1)

  • Output: echo_bravo.quebec_seven, (five(*))
  • Sort Key: (five(*)) DESC
  • Sort Method: quicksort Memory: 31kB
  • Buffers: shared hit=28152
2. 8.761 7,925.184 ↓ 1.9 144 1

GroupAggregate (cost=5.610..23,410.300 rows=76 width=12) (actual time=70.747..7,925.184 rows=144 loops=1)

  • Output: echo_bravo.quebec_seven, five(*)
  • Group Key: echo_bravo.quebec_seven
  • Buffers: shared hit=28149
3. 10.072 7,916.423 ↓ 274.8 20,881 1

Nested Loop (cost=5.610..23,409.160 rows=76 width=4) (actual time=4.778..7,916.423 rows=20,881 loops=1)

  • Output: echo_bravo.quebec_seven
  • Buffers: shared hit=28149
4. 3.467 29.139 ↓ 11.6 6,322 1

Nested Loop (cost=5.190..17,411.700 rows=547 width=8) (actual time=2.215..29.139 rows=6,322 loops=1)

  • Output: echo_bravo.quebec_seven, six_november.quebec_seven
  • Buffers: shared hit=6478
5. 0.384 4.216 ↓ 1.6 144 1

Nested Loop Semi Join (cost=0.450..1,309.020 rows=91 width=4) (actual time=2.035..4.216 rows=144 loops=1)

  • Output: echo_bravo.quebec_seven
  • Join Filter: (echo_bravo.zulu = tango_quebec.quebec_seven)
  • Rows Removed by Join Filter: 312
  • Buffers: shared hit=742
6. 1.816 1.816 ↑ 1.0 144 1

Index Scan using bravo_india on bravo_kilo (cost=0.420..1,147.000 rows=144 width=8) (actual time=0.085..1.816 rows=144 loops=1)

  • Output: echo_bravo.quebec_seven, echo_bravo.uniform, echo_bravo.quebec_zulu, echo_bravo.alpha_victor, echo_bravo.bravo_zulu, echo_bravo.tango_romeo, echo_bravo.india_foxtrot, echo_bravo.zulu, echo_bravo.alpha_two, echo_bravo.juliet_golf, echo_bravo.mike_hotel, echo_bravo.november
  • Index Cond: (echo_bravo.quebec_seven = ANY ('mike_three'::integer[]))
  • Buffers: shared hit=558
7. 2.016 2.016 ↑ 16.7 3 144

Function Scan on golf_bravo (cost=0.030..0.530 rows=50 width=4) (actual time=0.014..0.014 rows=3 loops=144)

  • Output: tango_quebec.quebec_seven
  • Function Call: get_purchasable_packages_under_packages('{128}'::integer[])
  • Buffers: shared hit=184
8. 18.720 21.456 ↑ 1.1 44 144

Bitmap Heap Scan on two_india (cost=4.740..176.470 rows=48 width=8) (actual time=0.028..0.149 rows=44 loops=144)

  • Output: six_november.quebec_seven, six_november.hotel, six_november.four_victor, six_november.four_charlie, six_november.two_seven, six_november.lima, six_november.six_three, six_november.quebec_zulu, six_november.india_lima, six_november.india_india, six_november.six_quebec, six_november.yankee, six_november.tango_three
  • Recheck Cond: (six_november.hotel = echo_bravo.quebec_seven)
  • Heap Blocks: exact=5281
  • Buffers: shared hit=5736
9. 2.736 2.736 ↑ 1.1 44 144

Bitmap Index Scan on oscar (cost=0.000..4.730 rows=48 width=0) (actual time=0.019..0.019 rows=44 loops=144)

  • Index Cond: (six_november.hotel = echo_bravo.quebec_seven)
  • Buffers: shared hit=455
10. 7,877.212 7,877.212 ↑ 4.7 3 6,322

Index Scan using golf_november on delta (cost=0.420..10.820 rows=14 width=4) (actual time=0.179..1.246 rows=3 loops=6,322)

  • Output: quebec_mike.quebec_seven, quebec_mike.xray, quebec_mike.echo_hotel, quebec_mike.charlie_uniform, quebec_mike.juliet_tango, quebec_mike.charlie_three, quebec_mike.lima, quebec_mike.quebec_zulu
  • Index Cond: (quebec_mike.xray = six_november.quebec_seven)
  • Filter: ((quebec_mike.quebec_zulu >= november((CURRENT_DATE)::timestamp with time zone, 1, 0)) AND (quebec_mike.quebec_zulu <= november((CURRENT_DATE)::timestamp with time zone, 0, 0)))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=21671
Planning time : 10.382 ms
Execution time : 7,925.613 ms