explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5ajR

Settings
# exclusive inclusive rows x rows loops node
1. 0.117 2,004.021 ↑ 220.8 24 1

Subquery Scan on yankee_juliet (cost=18,438.180..19,077.770 rows=5,298 width=140) (actual time=1,878.322..2,004.021 rows=24 loops=1)

  • Buffers: shared hit=116820, temp read=356 written=357
2. 0.089 2,003.904 ↑ 220.8 24 1

GroupAggregate (cost=18,438.180..18,971.810 rows=5,298 width=76) (actual time=1,878.305..2,003.904 rows=24 loops=1)

  • Group Key: hotel_quebec.yankee_india, zulu_two.zulu_zulu, kilo_foxtrot.seven
  • Buffers: shared hit=116820, temp read=356 written=357
3. 167.417 2,003.815 ↑ 64.9 48 1

Gather Merge (cost=18,438.180..18,866.630 rows=3,116 width=76) (actual time=1,862.318..2,003.815 rows=48 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Buffers: shared hit=252960, temp read=1087 written=1090
4. 87.888 1,836.398 ↑ 129.8 24 2 / 2

GroupAggregate (cost=17,438.170..17,516.070 rows=3,116 width=76) (actual time=1,724.890..1,836.398 rows=24 loops=2)

  • Group Key: hotel_quebec.yankee_india, zulu_two.zulu_zulu, kilo_foxtrot.seven
  • Buffers: shared hit=252960, temp read=1087 written=1090
5. 194.034 1,748.510 ↓ 13.4 41,724 2 / 2

Sort (cost=17,438.170..17,445.960 rows=3,116 width=53) (actual time=1,724.488..1,748.510 rows=41,724 loops=2)

  • Sort Key: hotel_quebec.yankee_india, zulu_two.zulu_zulu, kilo_foxtrot.seven
  • Sort Method: quicksort Memory: 3959kB
  • Buffers: shared hit=252960, temp read=1087 written=1090
6. 250.215 1,554.476 ↓ 13.4 41,724 2 / 2

Nested Loop (cost=15,304.420..17,257.360 rows=3,116 width=53) (actual time=553.400..1,554.476 rows=41,724 loops=2)

  • Buffers: shared hit=252942, temp read=856 written=859
7. 156.541 928.741 ↓ 13.4 41,724 2 / 2

Merge Join (cost=15,304.130..16,185.970 rows=3,116 width=61) (actual time=553.377..928.741 rows=41,724 loops=2)

  • Buffers: shared hit=2250, temp read=856 written=859
8. 580.157 721.519 ↑ 1.2 91,248 2 / 2

Sort (cost=15,225.530..15,501.300 rows=110,308 width=25) (actual time=552.068..721.519 rows=91,248 loops=2)

  • Sort Key: hotel_quebec.seven, hotel_quebec.yankee_india
  • Sort Method: external merge Disk: 2848kB
  • Buffers: shared hit=2241, temp read=856 written=859
9. 141.362 141.362 ↑ 1.2 93,650 2 / 2

Seq Scan on sierra hotel_quebec (cost=0.000..3,344.080 rows=110,308 width=25) (actual time=0.007..141.362 rows=93,650 loops=2)

  • Buffers: shared hit=2241
10. 50.657 50.681 ↓ 35.7 40,324 2 / 2

Sort (cost=78.600..81.430 rows=1,130 width=40) (actual time=0.065..50.681 rows=40,324 loops=2)

  • Sort Key: zulu_two.seven, zulu_two.india
  • Sort Method: quicksort Memory: 26kB
  • Buffers: shared hit=9
11. 0.024 0.024 ↑ 47.1 24 2 / 2

Seq Scan on whiskey_delta zulu_two (cost=0.000..21.300 rows=1,130 width=40) (actual time=0.017..0.024 rows=24 loops=2)

  • Buffers: shared hit=2
12. 375.520 375.520 ↑ 1.0 1 83,449 / 2

Index Only Scan using hotel_juliet on kilo_whiskey kilo_foxtrot (cost=0.290..0.340 rows=1 width=8) (actual time=0.009..0.009 rows=1 loops=83,449)

  • Index Cond: ((kilo_foxtrot.juliet = hotel_quebec.whiskey_seven) AND (kilo_foxtrot.seven = hotel_quebec.seven))
  • Heap Fetches: 38574
  • Buffers: shared hit=250692
Planning time : 2.449 ms
Execution time : 2,004.538 ms