explain.depesz.com

PostgreSQL's explain analyze made readable

Result: g59u : staging-ea-ve-fk

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 8,130.654 ↓ 0.0 0 1

Limit (cost=24,059.97..24,060.00 rows=1 width=68) (actual time=8,130.654..8,130.654 rows=0 loops=1)

2. 0.002 8,130.653 ↓ 0.0 0 1

GroupAggregate (cost=24,059.97..24,060.00 rows=1 width=68) (actual time=8,130.653..8,130.653 rows=0 loops=1)

  • Group Key: juliet.quebec
3. 0.006 8,130.651 ↓ 0.0 0 1

Sort (cost=24,059.97..24,059.97 rows=1 width=211) (actual time=8,130.651..8,130.651 rows=0 loops=1)

  • Sort Key: juliet.quebec
  • Sort Method: quicksort Memory: 25kB
4. 1.767 8,130.645 ↓ 0.0 0 1

Nested Loop (cost=3.24..24,059.96 rows=1 width=211) (actual time=8,130.645..8,130.645 rows=0 loops=1)

  • Join Filter: ("alpha"."romeo" = seven_lima2."romeo")
5. 1.821 8,125.214 ↓ 229.0 229 1

Nested Loop Anti Join (cost=2.68..24,058.21 rows=1 width=223) (actual time=85.214..8,125.214 rows=229 loops=1)

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

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

7. 0.641 55.576 ↓ 236.0 236 1

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

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

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

9. 0.954 52.413 ↓ 51.0 51 1

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

10. 10.473 10.473 ↓ 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.045..10.473 rows=20,493 loops=1)

  • Index Cond: (("sierra")::text = 'whiskey_romeo'::text)
11. 40.986 40.986 ↓ 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.002..0.002 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.561 0.561 ↑ 1.0 1 51

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

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

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

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

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

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

Seq Scan on lima_echo delta_six (cost=0.00..9,111.89 rows=27 width=4) (actual time=16.246..34.171 rows=24 loops=236)

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

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

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