explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mVYr : staging-ea-fk

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 7,072.496 ↓ 0.0 0 1

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

2. 0.002 7,072.495 ↓ 0.0 0 1

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

  • Group Key: juliet.quebec
3. 0.008 7,072.493 ↓ 0.0 0 1

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

  • Sort Key: juliet.quebec
  • Sort Method: quicksort Memory: 25kB
4. 2.010 7,072.485 ↓ 0.0 0 1

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

  • Join Filter: ("alpha"."romeo" = seven_lima2."romeo")
5. 1.870 7,065.895 ↓ 229.0 229 1

Nested Loop Anti Join (cost=2.68..24,058.21 rows=1 width=223) (actual time=28.220..7,065.895 rows=229 loops=1)

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

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

7. 0.596 46.836 ↓ 236.0 236 1

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

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

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

9. 15.375 43.826 ↓ 51.0 51 1

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

10. 7.958 7.958 ↓ 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.109..7.958 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.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.581 1.581 ↓ 2.5 5 51

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

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

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

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

Seq Scan on lima_echo delta_six (cost=0.00..9,111.89 rows=27 width=4) (actual time=14.328..29.724 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 : 6.223 ms
Execution time : 7,072.635 ms