explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QU1M

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 28,280.693 ↑ 1.0 1 1

Limit (cost=264,772,901.090..264,772,901.090 rows=1 width=2,521) (actual time=28,280.692..28,280.693 rows=1 loops=1)

2. 191.435 28,280.691 ↑ 72,170.0 1 1

Sort (cost=264,772,901.090..264,773,081.510 rows=72,170 width=2,521) (actual time=28,280.691..28,280.691 rows=1 loops=1)

  • Sort Key: bravo_foxtrot.echo_lima DESC
  • Sort Method: top-N heapsort Memory: 27kB
3. 525.025 28,089.256 ↓ 1.8 132,729 1

Nested Loop (cost=1.000..264,772,540.240 rows=72,170 width=2,521) (actual time=8.744..28,089.256 rows=132,729 loops=1)

4. 247.505 247.505 ↓ 1.8 8,123 1

Index Scan using india_lima on foxtrot (cost=0.430..6,854.650 rows=4,512 width=4) (actual time=0.027..247.505 rows=8,123 loops=1)

  • Index Cond: (sierra_three = 1632)
5. 9,398.311 9,398.311 ↑ 21.5 16 8,123

Index Scan using mike_five on bravo_foxtrot (cost=0.570..487.500 rows=344 width=2,521) (actual time=0.204..1.157 rows=16 loops=8,123)

  • Index Cond: (tango = foxtrot.quebec)
  • Filter: ((echo_lima five_romeo NOT NULL) AND (echo_lima < 'hotel'::timestamp without time zone))
  • Rows Removed by Filter: 0
6.          

SubPlan (forNested Loop)

7. 3,185.496 3,185.496 ↓ 0.0 0 132,729

Index Only Scan using romeo_whiskey on two_oscar (cost=0.560..8.020 rows=74 width=0) (actual time=0.024..0.024 rows=0 loops=132,729)

  • Index Cond: ((mike_india = bravo_foxtrot.quebec) AND (mike_juliet five_romeo NULL))
  • Heap Fetches: 503
8. 0.000 0.000 ↓ 0.0 0

Seq Scan on two_oscar five_whiskey (cost=0.000..350,847.840 rows=11,904,528 width=4) (never executed)

  • Filter: (mike_juliet five_romeo NULL)
9. 265.458 4,645.515 ↑ 1.0 1 132,729

Aggregate (cost=1,196.130..1,196.140 rows=1 width=8) (actual time=0.034..0.035 rows=1 loops=132,729)

10. 4,380.057 4,380.057 ↑ 1,343.0 1 132,729

Index Scan using echo_three on sierra_four (cost=0.570..1,192.770 rows=1,343 width=8) (actual time=0.027..0.033 rows=1 loops=132,729)

  • Index Cond: (mike_india = bravo_foxtrot.quebec)
11. 132.729 1,858.206 ↑ 1.0 1 132,729

Aggregate (cost=1,199.020..1,199.030 rows=1 width=8) (actual time=0.014..0.014 rows=1 loops=132,729)

12. 1,725.477 1,725.477 ↑ 1,157.0 1 132,729

Index Scan using echo_three on sierra_four romeo_zulu (cost=0.570..1,196.130 rows=1,157 width=8) (actual time=0.010..0.013 rows=1 loops=132,729)

  • Index Cond: (mike_india = bravo_foxtrot.quebec)
  • Filter: ((juliet_charlie)::text = 'juliet_lima'::text)
  • Rows Removed by Filter: 0
13. 0.000 3,052.767 ↑ 1.0 1 132,729

Aggregate (cost=41.210..41.220 rows=1 width=8) (actual time=0.023..0.023 rows=1 loops=132,729)

14. 3,052.767 3,052.767 ↓ 0.0 0 132,729

Index Scan using whiskey on sierra_four uniform (cost=0.570..41.110 rows=37 width=8) (actual time=0.023..0.023 rows=0 loops=132,729)

  • Index Cond: (((juliet_charlie)::text = 'delta'::text) AND (mike_india = bravo_foxtrot.quebec))
15. 0.000 3,052.767 ↑ 1.0 1 132,729

Aggregate (cost=2.690..2.700 rows=1 width=8) (actual time=0.023..0.023 rows=1 loops=132,729)

16. 3,052.767 3,052.767 ↓ 0.0 0 132,729

Index Scan using two_two on sierra_four india_five (cost=0.570..2.690 rows=1 width=8) (actual time=0.023..0.023 rows=0 loops=132,729)

  • Index Cond: ((juliet_charlie)::text = 'six'::text)
  • Filter: (mike_india = bravo_foxtrot.quebec)
17. 132.729 2,123.664 ↑ 1.0 1 132,729

Aggregate (cost=1,198.180..1,198.190 rows=1 width=8) (actual time=0.016..0.016 rows=1 loops=132,729)

18. 1,990.935 1,990.935 ↓ 0.0 0 132,729

Index Scan using echo_three on sierra_four bravo_five (cost=0.570..1,197.810 rows=149 width=8) (actual time=0.013..0.015 rows=0 loops=132,729)

  • Index Cond: (mike_india = bravo_foxtrot.quebec)
  • Filter: ((juliet_charlie)::text <> november ('kilo'::text[]))
  • Rows Removed by Filter: 1
Planning time : 4.655 ms
Execution time : 28,280.994 ms