explain.depesz.com

PostgreSQL's explain analyze made readable

Result: V5xh : Optimization for: staging-ea-ve-fk; plan #g59u

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.001 6,301.380 ↓ 0.0 0 1

Limit (cost=24,067.93..24,067.96 rows=1 width=68) (actual time=6,301.380..6,301.380 rows=0 loops=1)

2. 0.002 6,301.379 ↓ 0.0 0 1

GroupAggregate (cost=24,067.93..24,067.96 rows=1 width=68) (actual time=6,301.379..6,301.379 rows=0 loops=1)

  • Group Key: juliet.quebec
3. 0.004 6,301.377 ↓ 0.0 0 1

Sort (cost=24,067.93..24,067.94 rows=1 width=211) (actual time=6,301.377..6,301.377 rows=0 loops=1)

  • Sort Key: juliet.quebec
  • Sort Method: quicksort Memory: 25kB
4. 1.970 6,301.373 ↓ 0.0 0 1

Nested Loop (cost=3.24..24,067.92 rows=1 width=211) (actual time=6,301.373..6,301.373 rows=0 loops=1)

  • Join Filter: ("alpha"."romeo" = seven_lima2."romeo")
5. 1.833 6,294.823 ↓ 229.0 229 1

Nested Loop Anti Join (cost=2.68..24,066.17 rows=1 width=223) (actual time=30.905..6,294.823 rows=229 loops=1)

  • Join Filter: (delta_six."romeo" = juliet.quebec)
  • Rows Removed by Join Filter: 5,725
6. 1.212 47.722 ↓ 236.0 236 1

Nested Loop Anti Join (cost=2.68..14,945.99 rows=1 width=223) (actual time=0.083..47.722 rows=236 loops=1)

7. 0.536 45.566 ↓ 236.0 236 1

Nested Loop (cost=2.12..14,941.53 rows=1 width=223) (actual time=0.076..45.566 rows=236 loops=1)

  • Join Filter: (juliet.quebec = "alpha"."romeo")
8. 0.258 43.398 ↓ 51.0 51 1

Nested Loop (cost=1.56..14,939.32 rows=1 width=99) (actual time=0.064..43.398 rows=51 loops=1)

9. 14.213 42.630 ↓ 51.0 51 1

Nested Loop (cost=1.00..14,936.82 rows=1 width=95) (actual time=0.049..42.630 rows=51 loops=1)

10. 7.924 7.924 ↓ 4.7 20,493 1

Index Scan using charlie on juliet (cost=0.56..4,371.32 rows=4,402 width=4) (actual time=0.027..7.924 rows=20,493 loops=1)

  • Index Cond: (("sierra")::text = 'whiskey_romeo'::text)
11. 20.493 20.493 ↓ 0.0 0 20,493

Index Scan using oscar on seven_delta lima_delta (cost=0.43..2.40 rows=1 width=91) (actual time=0.001..0.001 rows=0 loops=20,493)

  • Index Cond: (("romeo" = juliet.quebec) AND ((november)::text = 'two'::text))
  • Filter: (((zulu())::date >= (("seven_five" + 'delta_bravo'::interval uniform))::date) AND ("yankee" = ANY ('whiskey_zulu'::integer[])))
12. 0.510 0.510 ↑ 1.0 1 51

Index Only Scan using bravo on alpha mike (cost=0.56..2.51 rows=1 width=4) (actual time=0.010..0.010 rows=1 loops=51)

  • Index Cond: (("romeo" = juliet.quebec) AND (foxtrot_quebec = 'lima_six'::text))
  • Heap Fetches: 51
13. 1.632 1.632 ↓ 2.5 5 51

Index Scan using bravo on alpha (cost=0.56..2.18 rows=2 width=124) (actual time=0.005..0.032 rows=5 loops=51)

  • Index Cond: ("romeo" = mike."romeo")
14. 0.944 0.944 ↓ 0.0 0 236

Index Only Scan using bravo on alpha hotel (cost=0.56..2.51 rows=1 width=4) (actual time=0.004..0.004 rows=0 loops=236)

  • Index Cond: (("romeo" = juliet.quebec) AND (foxtrot_quebec = 'echo'::text))
  • Heap Fetches: 0
15. 6,245.268 6,245.268 ↑ 1.1 24 236

Seq Scan on lima_echo delta_six (cost=0.00..9,119.85 rows=27 width=4) (actual time=12.960..26.463 rows=24 loops=236)

  • Filter: ("seven_oscar" = 1,006)
  • Rows Removed by Filter: 100,424
16. 4.580 4.580 ↓ 0.0 0 229

Index Scan using bravo on alpha foxtrot_hotel (cost=0.56..1.73 rows=1 width=4) (actual time=0.020..0.020 rows=0 loops=229)

  • Index Cond: (("romeo" = mike."romeo") AND ((foxtrot_quebec)::text = 'foxtrot_sierra'::text))
  • Filter: (("six")::text = 'india'::text)
Planning time : 7.978 ms
Execution time : 6,301.470 ms