explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RUMNF

Settings
# exclusive inclusive rows x rows loops node
1. 1,558.332 105,694.731 ↓ 24.1 90,103 1

Sort (cost=584,260.920..584,270.270 rows=3,739 width=1,151) (actual time=105,508.807..105,694.731 rows=90,103 loops=1)

  • Sort Key: november_mike.november_lima
  • Sort Method: external merge Disk: 54376kB
2. 81,378.767 104,136.399 ↓ 24.1 90,103 1

Nested Loop (cost=6,287.610..582,159.540 rows=3,739 width=1,151) (actual time=229.164..104,136.399 rows=90,103 loops=1)

3. 22.044 22.044 ↑ 1.0 1 1

Index Scan using bravo_yankee on kilo_foxtrot tango_mike (cost=0.430..8.450 rows=1 width=16) (actual time=22.033..22.044 rows=1 loops=1)

  • Index Cond: (quebec_seven_victor_foxtrot = 'sierra'::bigint)
4. 157.239 9,850.859 ↓ 24.1 90,103 1

Hash Left Join (cost=6,287.180..52,481.850 rows=3,739 width=424) (actual time=203.746..9,850.859 rows=90,103 loops=1)

  • Hash Cond: (november_mike.quebec_seven_victor_foxtrot = uniform_delta.mike_yankee)
5. 252.436 9,633.887 ↓ 24.1 90,103 1

Nested Loop (cost=5,166.400..51,300.300 rows=3,739 width=408) (actual time=143.993..9,633.887 rows=90,103 loops=1)

  • Join Filter: ((NOT lima_four.bravo_oscar) OR (november_mike.romeo <> 4864001) OR (lima_sierra(lima_four.seven_four, 'four_five'::bigint[]) && 'four_five'::bigint[]))
6. 212.079 7,579.391 ↓ 23.5 90,103 1

Nested Loop (cost=5,166.150..51,204.270 rows=3,831 width=398) (actual time=143.851..7,579.391 rows=90,103 loops=1)

7. 4,619.147 4,754.325 ↓ 23.2 90,103 1

Bitmap Heap Scan on uniform_hotel november_mike (cost=5,165.720..20,263.930 rows=3,879 width=358) (actual time=143.780..4,754.325 rows=90,103 loops=1)

  • Recheck Cond: ((seven_golf = 'sierra'::bigint) AND (romeo = 'quebec_november'::bigint))
  • Filter: ((NOT foxtrot_six) AND (bravo_six = 'four_uniform'::smallint) AND (quebec_seven_victor_alpha = ANY ('foxtrot_papa'::integer[])))
  • Heap Blocks: exact=11552
8. 2.053 135.178 ↓ 0.0 0 1

BitmapAnd (cost=5,165.720..5,165.720 rows=4,226 width=0) (actual time=135.178..135.178 rows=0 loops=1)

9. 52.700 52.700 ↓ 1.0 90,103 1

Bitmap Index Scan on papa (cost=0.000..1,635.060 rows=88,351 width=0) (actual time=52.700..52.700 rows=90,103 loops=1)

  • Index Cond: (seven_golf = 'sierra'::bigint)
10. 80.425 80.425 ↓ 1.0 198,057 1

Bitmap Index Scan on lima_oscar (cost=0.000..3,528.460 rows=190,938 width=0) (actual time=80.425..80.425 rows=198,057 loops=1)

  • Index Cond: (romeo = 'quebec_november'::bigint)
11. 2,612.987 2,612.987 ↑ 1.0 1 90,103

Index Scan using echo_romeo on tango_six juliet (cost=0.430..7.970 rows=1 width=48) (actual time=0.028..0.029 rows=1 loops=90,103)

  • Index Cond: (quebec_seven_victor_foxtrot = november_mike.mike_juliet)
  • Filter: (NOT alpha_papa)
12. 1,802.060 1,802.060 ↑ 1.0 1 90,103

Function Scan on charlie_papa lima_four (cost=0.250..0.260 rows=1 width=33) (actual time=0.019..0.020 rows=1 loops=90,103)

13. 0.181 59.733 ↑ 1.3 241 1

Hash (cost=1,116.910..1,116.910 rows=310 width=24) (actual time=59.733..59.733 rows=241 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 22kB
14. 38.082 59.552 ↑ 1.3 241 1

Bitmap Heap Scan on foxtrot_three uniform_delta (cost=24.830..1,116.910 rows=310 width=24) (actual time=34.782..59.552 rows=241 loops=1)

  • Recheck Cond: (romeo = 4864001)
  • Filter: (mike_alpha = 2)
  • Rows Removed by Filter: 831
  • Heap Blocks: exact=569
15. 21.470 21.470 ↑ 1.0 1,076 1

Bitmap Index Scan on uniform_echo (cost=0.000..24.750 rows=1,111 width=0) (actual time=21.470..21.470 rows=1,076 loops=1)

  • Index Cond: (romeo = 4864001)
16.          

SubPlan (forNested Loop)

17. 360.412 360.412 ↓ 0.0 0 90,103

Index Scan using three on foxtrot_three (cost=0.420..8.440 rows=1 width=8) (actual time=0.004..0.004 rows=0 loops=90,103)

  • Index Cond: (mike_yankee = november_mike.quebec_seven_victor_foxtrot)
  • Filter: ((mike_alpha = 3) AND (romeo = 4864001))
  • Rows Removed by Filter: 0
18. 360.412 630.721 ↓ 0.0 0 90,103

Sort (cost=11.160..11.160 rows=1 width=8) (actual time=0.007..0.007 rows=0 loops=90,103)

  • Sort Key: echo_five.quebec_seven_victor_foxtrot
  • Sort Method: quicksort Memory: 25kB
19. 270.309 270.309 ↓ 0.0 0 90,103

Index Scan using charlie_hotel on echo_five (cost=0.420..11.150 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=90,103)

  • Index Cond: (mike_six = uniform_delta.quebec_seven_victor_foxtrot)
  • Filter: (lima_sierra(lima_romeo, 'kilo_golf'::bigint) >= 1543794371)
20. 90.103 180.206 ↓ 0.0 0 90,103

Sort (cost=11.410..11.410 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=90,103)

  • Sort Key: delta_charlie1.quebec_seven_victor_foxtrot
  • Sort Method: quicksort Memory: 25kB
21. 90.103 90.103 ↓ 0.0 0 90,103

Index Scan using charlie_hotel on echo_five five (cost=0.420..11.400 rows=1 width=40) (actual time=0.001..0.001 rows=0 loops=90,103)

  • Index Cond: (mike_six = uniform_delta.quebec_seven_victor_foxtrot)
  • Filter: (lima_sierra(lima_romeo, 'kilo_golf'::bigint) >= 1543794371)
22. 90.103 180.206 ↓ 0.0 0 90,103

Sort (cost=19.600..19.600 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=90,103)

  • Sort Key: ((delta_four 4))
  • Sort Method: quicksort Memory: 25kB
23. 51.267 90.103 ↓ 0.0 0 90,103

Index Scan using charlie_hotel on echo_five golf_quebec (cost=0.420..19.590 rows=1 width=8) (actual time=0.001..0.001 rows=0 loops=90,103)

  • Index Cond: (mike_six = uniform_delta.quebec_seven_victor_foxtrot)
  • Filter: (lima_sierra(lima_romeo, 'kilo_golf'::bigint) >= 1543794371)
24.          

SubPlan (forIndex Scan)

25. 38.836 38.836 ↑ 1.0 1 19

Index Scan using victor_alpha on tango_whiskey quebec_sierra (cost=0.420..8.440 rows=1 width=8) (actual time=2.043..2.044 rows=1 loops=19)

  • Index Cond: ((romeo = uniform_delta.romeo) AND (tango_juliet = delta_charlie2.zulu_lima))
26. 180.206 180.206 ↓ 0.0 0 90,103

Sort (cost=19.600..19.600 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=90,103)

  • Sort Key: delta_charlie3.quebec_seven_victor_foxtrot
  • Sort Method: quicksort Memory: 25kB
27. 0.000 0.000 ↓ 0.0 0 90,103

Index Scan using charlie_hotel on echo_five xray (cost=0.420..19.590 rows=1 width=40) (actual time=0.000..0.000 rows=0 loops=90,103)

  • Index Cond: (mike_six = uniform_delta.quebec_seven_victor_foxtrot)
  • Filter: (lima_sierra(lima_romeo, 'kilo_golf'::bigint) >= 1543794371)
28.          

SubPlan (forIndex Scan)

29. 0.095 0.095 ↑ 1.0 1 19

Index Scan using victor_alpha on tango_whiskey zulu_zulu (cost=0.420..8.440 rows=1 width=19) (actual time=0.005..0.005 rows=1 loops=19)

  • Index Cond: ((romeo = uniform_delta.romeo) AND (tango_juliet = delta_charlie3.zulu_lima))
30. 180.206 180.206 ↓ 0.0 0 90,103

Sort (cost=11.160..11.160 rows=1 width=12) (actual time=0.002..0.002 rows=0 loops=90,103)

  • Sort Key: delta_charlie4.quebec_seven_victor_foxtrot
  • Sort Method: quicksort Memory: 25kB
31. 0.000 0.000 ↓ 0.0 0 90,103

Index Scan using charlie_hotel on echo_five alpha_hotel (cost=0.420..11.150 rows=1 width=12) (actual time=0.000..0.000 rows=0 loops=90,103)

  • Index Cond: (mike_six = uniform_delta.quebec_seven_victor_foxtrot)
  • Filter: (lima_sierra(lima_romeo, 'kilo_golf'::bigint) >= 1543794371)
32. 180.206 180.206 ↓ 0.0 0 90,103

Sort (cost=11.410..11.410 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=90,103)

  • Sort Key: delta_charlie5.quebec_seven_victor_foxtrot
  • Sort Method: quicksort Memory: 25kB
33. 0.000 0.000 ↓ 0.0 0 90,103

Index Scan using charlie_hotel on echo_five charlie_golf (cost=0.420..11.400 rows=1 width=40) (actual time=0.000..0.000 rows=0 loops=90,103)

  • Index Cond: (mike_six = uniform_delta.quebec_seven_victor_foxtrot)
  • Filter: (lima_sierra(lima_romeo, 'kilo_golf'::bigint) >= 1543794371)
34. 180.206 180.206 ↓ 0.0 0 90,103

Sort (cost=11.410..11.410 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=90,103)

  • Sort Key: delta_charlie6.quebec_seven_victor_foxtrot
  • Sort Method: quicksort Memory: 25kB
35. 0.000 0.000 ↓ 0.0 0 90,103

Index Scan using charlie_hotel on echo_five victor_zulu (cost=0.420..11.400 rows=1 width=40) (actual time=0.000..0.000 rows=0 loops=90,103)

  • Index Cond: (mike_six = uniform_delta.quebec_seven_victor_foxtrot)
  • Filter: (lima_sierra(lima_romeo, 'kilo_golf'::bigint) >= 1543794371)
36. 180.206 180.206 ↓ 0.0 0 90,103

Sort (cost=11.410..11.410 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=90,103)

  • Sort Key: delta_charlie7.quebec_seven_victor_foxtrot
  • Sort Method: quicksort Memory: 25kB
37. 0.000 0.000 ↓ 0.0 0 90,103

Index Scan using charlie_hotel on echo_five hotel (cost=0.420..11.400 rows=1 width=40) (actual time=0.000..0.000 rows=0 loops=90,103)

  • Index Cond: (mike_six = uniform_delta.quebec_seven_victor_foxtrot)
  • Filter: (lima_sierra(lima_romeo, 'kilo_golf'::bigint) >= 1543794371)
38. 180.206 180.206 ↓ 0.0 0 90,103

Sort (cost=11.160..11.160 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=90,103)

  • Sort Key: delta_charlie8.quebec_seven_victor_foxtrot
  • Sort Method: quicksort Memory: 25kB
39. 0.000 0.000 ↓ 0.0 0 90,103

Index Scan using charlie_hotel on echo_five quebec_tango (cost=0.420..11.150 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=90,103)

  • Index Cond: (mike_six = uniform_delta.quebec_seven_victor_foxtrot)
  • Filter: (lima_sierra(lima_romeo, 'kilo_golf'::bigint) >= 1543794371)
40. 1,441.648 1,441.648 ↓ 0.0 0 90,103

Seq Scan on golf_romeo (cost=0.000..2.900 rows=1 width=8) (actual time=0.016..0.016 rows=0 loops=90,103)

  • Filter: (mike_yankee = november_mike.quebec_seven_victor_foxtrot)
  • Rows Removed by Filter: 72
41. 9,010.300 9,010.300 ↑ 1.0 1 90,103

Index Scan using tango_delta on golf_six (cost=0.430..8.450 rows=1 width=8) (actual time=0.100..0.100 rows=1 loops=90,103)

  • Index Cond: (mike_yankee = november_mike.quebec_seven_victor_foxtrot)