explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R2f

Settings
# exclusive inclusive rows x rows loops node
1. 2.083 5,557.575 ↓ 1.2 797 1
→

Sort (cost=19,182,871.070..19,182,872.690 rows=647 width=91) (actual time=5,557.547..5,557.575 rows=797 loops=1)

  • Sort Key: zulu_four.seven_six, four.seven_six
  • Sort Method: quicksort Memory: 99kB
2. 7.157 5,555.492 ↓ 1.2 797 1
→

HashAggregate (cost=19,182,829.540..19,182,840.870 rows=647 width=91) (actual time=5,555.184..5,555.492 rows=797 loops=1)

3. 1.248 207.849 ↓ 1.5 1,202 1
→

Hash Join (cost=26,519.420..26,866.750 rows=776 width=91) (actual time=202.593..207.849 rows=1,202 loops=1)

  • Hash Cond: (six.alpha_alpha = ((hotel_uniform1.alpha_alpha)::character varying)::bpchar)
4. 3.282 124.497 ↑ 5.4 1,202 1
→

GroupAggregate (cost=20,427.600..20,670.150 rows=6,468 width=53) (actual time=120.475..124.497 rows=1,202 loops=1)

5. 20.158 121.215 ↑ 1.2 5,191 1
→

Sort (cost=20,427.600..20,443.770 rows=6,468 width=53) (actual time=120.472..121.215 rows=5,191 loops=1)

  • Sort Key: (echo('quebec_four'::text, (november_four.papa_hotel)::timestamp without time zone)), (echo('kilo_lima'::text, (november_four.papa_hotel)::timestamp without time zone)), zulu_four.seven_six, four.seven_six, six.alpha_alpha
  • Sort Method: quicksort Memory: 612kB
6. 3.679 101.057 ↑ 1.2 5,191 1
→

Hash Join (cost=4,253.740..20,018.210 rows=6,468 width=53) (actual time=65.119..101.057 rows=5,191 loops=1)

  • Hash Cond: (november_four.charlie_four = foxtrot_four.quebec_seven)
7. 1.210 96.470 ↑ 1.2 5,191 1
→

Hash Join (cost=4,076.990..19,663.590 rows=6,468 width=57) (actual time=64.194..96.470 rows=5,191 loops=1)

  • Hash Cond: (five.whiskey_oscar = four.quebec_seven)
8. 1.351 95.252 ↑ 1.2 5,191 1
→

Hash Join (cost=4,075.520..19,573.180 rows=6,468 width=29) (actual time=64.180..95.252 rows=5,191 loops=1)

  • Hash Cond: (november_four.alpha_zulu = zulu_four.quebec_seven)
9. 6.369 93.833 ↑ 1.2 5,191 1
→

Nested Loop (cost=4,066.550..19,475.280 rows=6,468 width=26) (actual time=64.106..93.833 rows=5,191 loops=1)

10. 4.966 78.788 ↑ 1.2 8,676 1
→

Nested Loop (cost=4,066.130..14,360.240 rows=9,996 width=24) (actual time=64.095..78.788 rows=8,676 loops=1)

11. 19.744 67.791 ↑ 1.4 6,031 1
→

Hash Join (cost=4,065.710..9,907.370 rows=8,480 width=24) (actual time=64.075..67.791 rows=6,031 loops=1)

  • Hash Cond: (five.two_quebec = november_four.quebec_seven)
12. 23.467 23.467 ↓ 1.0 178,278
- 5,547 		1
→

Seq Scan on five (cost=0.000..3,974.250 rows=178,261 width=20) (actual time=0.003..23.467 rows=178,278 loops=1)

  • Filter: (NOT alpha_juliet)
  • Rows Removed by Filter: 5,547
13. 0.857 24.580 ↑ 1.0 5,653 1
→

Hash (cost=3,991.820..3,991.820 rows=5,911 width=20) (actual time=24.580..24.580 rows=5,653 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 310kB
14. 23.723 23.723 ↑ 1.0 5,653
- 118,602 		1
→

Seq Scan on november_four (cost=0.000..3,991.820 rows=5,911 width=20) (actual time=22.387..23.723 rows=5,653 loops=1)

  • Filter: ((papa_hotel <= 'alpha_foxtrot'::date) AND (papa_hotel >= 'kilo_india'::date))
  • Rows Removed by Filter: 118,602
15. 6.031 6.031 ↑ 2.0 6,031 6,031
→

Index Only Scan using victor_sierra on india_xray (cost=0.420..0.510 rows=2 width=16) (actual time=0.001..0.001 rows=1 loops=6,031)

  • Index Cond: (papa_xray = five.quebec_seven)
  • Heap Fetches: 8,676
16. 8.676 8.676 ↑ 1.0 8,676 8,676
→

Index Scan using seven_two on six (cost=0.420..0.500 rows=1 width=18) (actual time=0.001..0.001 rows=1 loops=8,676)

  • Index Cond: (quebec_seven = india_xray.two_echo)
  • Filter: ((two_charlie)::text = ANY ('yankee'::text[]))
  • Rows Removed by Filter: 0
17. 0.036 0.068 ↑ 1.0 265 1
→

Hash (cost=5.650..5.650 rows=265 width=11) (actual time=0.068..0.068 rows=265 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
18. 0.032 0.032 ↑ 1.0 265 1
→

Seq Scan on zulu_four (cost=0.000..5.650 rows=265 width=11) (actual time=0.002..0.032 rows=265 loops=1)

19. 0.003 0.008 ↑ 1.0 21 1
→

Hash (cost=1.210..1.210 rows=21 width=36) (actual time=0.008..0.008 rows=21 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
20. 0.005 0.005 ↑ 1.0 21 1
→

Seq Scan on four (cost=0.000..1.210 rows=21 width=36) (actual time=0.002..0.005 rows=21 loops=1)

21. 0.479 0.908 ↑ 1.0 3,900 1
→

Hash (cost=128.000..128.000 rows=3,900 width=4) (actual time=0.908..0.908 rows=3,900 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 138kB
22. 0.429 0.429 ↑ 1.0 3,900 1
→

Seq Scan on foxtrot_four (cost=0.000..128.000 rows=3,900 width=4) (actual time=0.003..0.429 rows=3,900 loops=1)

23. 0.020 82.104 ↓ 1.1 27 1
→

Hash (cost=6,091.520..6,091.520 rows=24 width=4) (actual time=82.104..82.104 rows=27 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
24. 48.528 82.084 ↓ 1.1 27 1
→

HashAggregate (cost=6,091.040..6,091.280 rows=24 width=4) (actual time=82.080..82.084 rows=27 loops=1)

25. 33.556 33.556 ↑ 1.0 309,603 1
→

Seq Scan on six sierra (cost=0.000..5,317.030 rows=309,603 width=4) (actual time=0.009..33.556 rows=309,603 loops=1)

26.          

SubPlan (for HashAggregate)
27. 1,322.090 5,340.486 ↑ 1.0 1,202 1,202
→

Result (cost=24,685.480..24,685.500 rows=1 width=0) (actual time=4.443..4.443 rows=1 loops=1,202)

28.          

InitPlan (for Result)
29. 1.174 2,617.956 ↑ 1.0 1,202 1,202
→

Result (cost=6,404.440..6,404.460 rows=1 width=0) (actual time=2.178..2.178 rows=1 loops=1,202)

30.          

InitPlan (for Result)
31. 2.164 2,616.782 ↓ 0.0 0 818
→

Nested Loop (cost=703.880..6,404.440 rows=1 width=7) (actual time=3.198..3.199 rows=0 loops=818)

32. 91.616 2,608.602 ↓ 0.0 0 818
→

GroupAggregate (cost=703.450..6,371.020 rows=1 width=12) (actual time=3.189..3.189 rows=0 loops=818)

33. 1,047.858 2,516.986 ↑ 2.8 753,378
- 11,186,150 		818
→

Bitmap Heap Scan on uniform_romeo charlie_kilo (cost=703.450..6,351.450 rows=2,608 width=12) (actual time=1.821..3.077 rows=921 loops=818)

  • Recheck Cond: ((india_hotel = ((hotel_uniform1.alpha_alpha)::character varying)::bpchar) AND (uniform_uniform = 'uniform_november'::bpchar) AND (hotel_tango <= 'foxtrot_alpha'::date))
  • Filter: quebec_zulu
  • Rows Removed by Filter: 13,675
34. 1,469.128 1,469.128 ↑ 1.7 11,939,528 818
→

Bitmap Index Scan on november_bravo (cost=0.000..702.800 rows=25,150 width=0) (actual time=1.796..1.796 rows=14,596 loops=818)

  • Index Cond: ((india_hotel = ((hotel_uniform1.alpha_alpha)::character varying)::bpchar) AND (uniform_uniform = 'uniform_november'::bpchar) AND (hotel_tango <= 'foxtrot_alpha'::date))
35. 6.016 6.016 ↑ 1.0 376
- 3,008 		376
→

Index Scan using november_bravo on uniform_romeo (cost=0.430..33.390 rows=1 width=11) (actual time=0.014..0.016 rows=1 loops=376)

  • Index Cond: ((india_hotel = ((hotel_uniform1.alpha_alpha)::character varying)::bpchar) AND (uniform_uniform = 'uniform_november'::bpchar) AND (hotel_tango = (alpha_four(foxtrot_yankee1.hotel_tango))) AND (hotel_tango <= 'foxtrot_alpha'::date))
  • Filter: quebec_zulu
  • Rows Removed by Filter: 8
36.          

InitPlan (for Result)
37. 2,061.030 2,721.836 ↑ 1.0 442 442
→

Result (cost=5,938.260..5,938.270 rows=1 width=0) (actual time=6.158..6.158 rows=1 loops=442)

38.          

InitPlan (for Result)
39. 1.339 2,720.952 ↑ 1.0 442 442
→

Nested Loop (cost=442.610..5,938.260 rows=1 width=7) (actual time=6.155..6.156 rows=1 loops=442)

40. 80.661 2,710.344 ↑ 1.0 442 442
→

GroupAggregate (cost=442.190..5,915.230 rows=1 width=12) (actual time=6.132..6.132 rows=1 loops=442)

41. 841.415 2,603.822 ↓ 1.2 884,884
- 11,262,160 		442
→

Bitmap Heap Scan on uniform_romeo three (cost=442.190..5,902.950 rows=1,637 width=12) (actual time=3.430..5.891 rows=2,002 loops=442)

  • Recheck Cond: ((india_hotel = 'uniform_november'::bpchar) AND (uniform_uniform = ((hotel_uniform1.alpha_alpha)::character varying)::bpchar) AND (hotel_tango <= 'foxtrot_alpha'::date))
  • Filter: quebec_zulu
  • Rows Removed by Filter: 25,480
42. 1,130.253 1,492.634 ↓ 1.7 12,147,044 442
→

Bitmap Index Scan on november_bravo (cost=0.000..441.780 rows=15,788 width=0) (actual time=3.377..3.377 rows=27,482 loops=442)

  • Index Cond: ((india_hotel = 'uniform_november'::bpchar) AND (uniform_uniform = ((hotel_uniform1.alpha_alpha)::character varying)::bpchar) AND (hotel_tango <= 'foxtrot_alpha'::date))
43. 6.694 8.840 ↑ 1.0 442
- 3,094 		442
→

Index Scan using november_bravo on uniform_romeo whiskey_yankee (cost=0.430..23.000 rows=1 width=11) (actual time=0.019..0.020 rows=1 loops=442)

  • Index Cond: ((india_hotel = 'uniform_november'::bpchar) AND (uniform_uniform = ((hotel_uniform1.alpha_alpha)::character varying)::bpchar) AND (hotel_tango = (alpha_four(foxtrot_yankee3.hotel_tango))) AND (hotel_tango <= 'foxtrot_alpha'::date))
  • Filter: quebec_zulu
  • Rows Removed by Filter: 7
44.          

InitPlan (for Result)
45. 0.000 0.000 ↓ 0.0 0
→

Result (cost=6,404.440..6,404.460 rows=1 width=0) (never executed)

46.          

InitPlan (for Result)
47. 0.000 0.000 ↓ 0.0 0
→

Nested Loop (cost=703.880..6,404.440 rows=1 width=7) (never executed)

48. 0.000 0.000 ↓ 0.0 0
→

GroupAggregate (cost=703.450..6,371.020 rows=1 width=12) (never executed)

49. 0.000 0.000 ↓ 0.0 0
→

Bitmap Heap Scan on uniform_romeo victor_bravo (cost=703.450..6,351.450 rows=2,608 width=12) (never executed)

  • Recheck Cond: ((india_hotel = ((hotel_uniform1.alpha_alpha)::character varying)::bpchar) AND (uniform_uniform = 'uniform_november'::bpchar) AND (hotel_tango <= 'foxtrot_alpha'::date))
  • Filter: quebec_zulu
50. 0.000 0.000 ↓ 0.0 0
→

Bitmap Index Scan on november_bravo (cost=0.000..702.800 rows=25,150 width=0) (never executed)

  • Index Cond: ((india_hotel = ((hotel_uniform1.alpha_alpha)::character varying)::bpchar) AND (uniform_uniform = 'uniform_november'::bpchar) AND (hotel_tango <= 'foxtrot_alpha'::date))
51. 0.000 0.000 ↓ 0.0 0
→

Index Scan using november_bravo on uniform_romeo quebec_uniform (cost=0.430..33.390 rows=1 width=11) (never executed)

  • Index Cond: ((india_hotel = ((hotel_uniform1.alpha_alpha)::character varying)::bpchar) AND (uniform_uniform = 'uniform_november'::bpchar) AND (hotel_tango = (alpha_four(foxtrot_yankee5.hotel_tango))) AND (hotel_tango <= 'foxtrot_alpha'::date))
  • Filter: quebec_zulu
52.          

InitPlan (for Result)
53. 0.000 0.000 ↓ 0.0 0
→

Result (cost=5,938.260..5,938.270 rows=1 width=0) (never executed)

54.          

InitPlan (for Result)
55. 0.000 0.000 ↓ 0.0 0
→

Nested Loop (cost=442.610..5,938.260 rows=1 width=7) (never executed)

56. 0.000 0.000 ↓ 0.0 0
→

GroupAggregate (cost=442.190..5,915.230 rows=1 width=12) (never executed)

57. 0.000 0.000 ↓ 0.0 0
→

Bitmap Heap Scan on uniform_romeo lima (cost=442.190..5,902.950 rows=1,637 width=12) (never executed)

  • Recheck Cond: ((india_hotel = 'uniform_november'::bpchar) AND (uniform_uniform = ((hotel_uniform1.alpha_alpha)::character varying)::bpchar) AND (hotel_tango <= 'foxtrot_alpha'::date))
  • Filter: quebec_zulu
58. 0.000 0.000 ↓ 0.0 0
→

Bitmap Index Scan on november_bravo (cost=0.000..441.780 rows=15,788 width=0) (never executed)

  • Index Cond: ((india_hotel = 'uniform_november'::bpchar) AND (uniform_uniform = ((hotel_uniform1.alpha_alpha)::character varying)::bpchar) AND (hotel_tango <= 'foxtrot_alpha'::date))
59. 0.000 0.000 ↓ 0.0 0
→

Index Scan using november_bravo on uniform_romeo zulu_foxtrot (cost=0.430..23.000 rows=1 width=11) (never executed)

  • Index Cond: ((india_hotel = 'uniform_november'::bpchar) AND (uniform_uniform = ((hotel_uniform1.alpha_alpha)::character varying)::bpchar) AND (hotel_tango = (alpha_four(foxtrot_yankee7.hotel_tango))) AND (hotel_tango <= 'foxtrot_alpha'::date))
  • Filter: quebec_zulu
60.          

InitPlan (for Result)
61. 0.000 0.000 ↓ 0.0 0
→

Result (cost=0.000..0.010 rows=1 width=0) (never executed)

62.          

InitPlan (for Result)
63. 0.000 0.000 ↓ 0.0 0
→

Result (cost=0.000..0.010 rows=1 width=0) (never executed)