explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SAz8 : staging-ea-no-fk

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 5,944.646 ↓ 0.0 0 1

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

2. 0.002 5,944.645 ↓ 0.0 0 1

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

  • Group Key: juliet.quebec
3. 0.022 5,944.643 ↓ 0.0 0 1

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

  • Sort Key: juliet.quebec
  • Sort Method: quicksort Memory: 25kB
4. 1.918 5,944.621 ↓ 0.0 0 1

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

  • Join Filter: ("alpha"."romeo" = seven_lima2."romeo")
5. 1.785 5,937.894 ↓ 229.0 229 1

Nested Loop Anti Join (cost=2.68..24,058.21 rows=1 width=223) (actual time=38.198..5,937.894 rows=229 loops=1)

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

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

7. 0.542 49.906 ↓ 236.0 236 1

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

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

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

9. 16.517 46.081 ↓ 51.0 51 1

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

10. 9.071 9.071 ↓ 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.119..9.071 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.969 0.969 ↑ 1.0 1 51

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

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

Index Scan using bravo on alpha (cost=0.56..2.18 rows=2 width=124) (actual time=0.005..0.041 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. 5,883.952 5,883.952 ↑ 1.1 24 236

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

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

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

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