explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8ksj

Settings
# exclusive inclusive rows x rows loops node
1. 0.731 1,765.821 ↑ 1.0 1 1

Aggregate (cost=56,551.03..56,551.04 rows=1 width=8) (actual time=1,765.820..1,765.821 rows=1 loops=1)

2. 3.374 1,765.090 ↑ 1.3 3,357 1

Group (cost=56,472.49..56,494.93 rows=4,488 width=12,906) (actual time=1,760.618..1,765.090 rows=3,357 loops=1)

  • Group Key: lima0.quebec_seven
3. 4.059 1,761.716 ↓ 1.1 4,862 1

Sort (cost=56,472.49..56,483.71 rows=4,488 width=4) (actual time=1,760.606..1,761.716 rows=4,862 loops=1)

  • Sort Key: lima0.quebec_seven
  • Sort Method: quicksort Memory: 420kB
4. 1,216.705 1,757.657 ↓ 1.1 4,862 1

Hash Left Join (cost=50,669.55..56,200.25 rows=4,488 width=4) (actual time=354.557..1,757.657 rows=4,862 loops=1)

  • Hash Cond: (lima3."five" = quebec_three1.quebec_seven)
  • Filter: (((lima0.november_lima)::text ~~* 'india'::text) OR ((quebec_three1.november_lima)::text ~~* 'india'::text) OR ((kilo2.november_lima)::text ~~* 'india'::text) OR (lima0.golf_india_mike ~~* 'india'::text) OR (lima0.zulu_mike ~~* 'india'::text))
  • Rows Removed by Filter: 83,264
5. 56.546 523.740 ↓ 1.2 88,126 1

Hash Left Join (cost=47,690.61..53,036.18 rows=70,501 width=190) (actual time=337.090..523.740 rows=88,126 loops=1)

  • Hash Cond: (lima4."golf_india_golf" = kilo2.quebec_seven)
6. 105.848 463.723 ↓ 1.2 88,126 1

Hash Right Join (cost=47,133.77..52,294.10 rows=70,501 width=181) (actual time=333.593..463.723 rows=88,126 loops=1)

  • Hash Cond: (lima4."bravo_charlie" = lima0.quebec_seven)
7. 24.506 24.506 ↑ 1.0 79,550 1

Seq Scan on alpha echo (cost=0.00..1,778.41 rows=80,241 width=8) (actual time=0.017..24.506 rows=79,550 loops=1)

8. 56.407 333.369 ↓ 1.2 80,665 1

Hash (cost=44,525.29..44,525.29 rows=68,839 width=177) (actual time=333.368..333.369 rows=80,665 loops=1)

  • Buckets: 32,768 (originally 32768) Batches: 8 (originally 4) Memory Usage: 3,841kB
9. 72.199 276.962 ↓ 1.2 80,665 1

Hash Right Join (cost=40,492.60..44,525.29 rows=68,839 width=177) (actual time=184.273..276.962 rows=80,665 loops=1)

  • Hash Cond: (lima3."bravo_charlie" = lima0.quebec_seven)
10. 20.718 20.718 ↑ 1.0 69,285 1

Seq Scan on november_seven bravo_zulu (cost=0.00..1,614.49 rows=70,549 width=8) (actual time=0.013..20.718 rows=69,285 loops=1)

11. 48.060 184.045 ↑ 1.0 65,968 1

Hash (cost=37,951.11..37,951.11 rows=68,839 width=173) (actual time=184.044..184.045 rows=65,968 loops=1)

  • Buckets: 32,768 Batches: 4 Memory Usage: 3,672kB
12. 135.985 135.985 ↑ 1.0 65,968 1

Seq Scan on juliet_sierra romeo_november (cost=0.00..37,951.11 rows=68,839 width=173) (actual time=0.014..135.985 rows=65,968 loops=1)

  • Filter: ((victor = 'juliet_alpha'::november_zulu) AND ("golf_november" < zulu_golf()))
  • Rows Removed by Filter: 8,844
13. 1.472 3.471 ↓ 1.0 4,366 1

Hash (cost=503.04..503.04 rows=4,304 width=17) (actual time=3.471..3.471 rows=4,366 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 277kB
14. 1.999 1.999 ↓ 1.0 4,366 1

Seq Scan on romeo_four yankee (cost=0.00..503.04 rows=4,304 width=17) (actual time=0.006..1.999 rows=4,366 loops=1)

15. 7.449 17.212 ↓ 1.0 20,976 1

Hash (cost=2,717.86..2,717.86 rows=20,886 width=16) (actual time=17.212..17.212 rows=20,976 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,243kB
16. 9.763 9.763 ↓ 1.0 20,976 1

Seq Scan on whiskey six (cost=0.00..2,717.86 rows=20,886 width=16) (actual time=0.005..9.763 rows=20,976 loops=1)

Planning time : 4.615 ms
Execution time : 1,766.069 ms