explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NG1U : staging-ea-no-fk

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 187,947.363 ↓ 0.0 0 1

Limit (cost=1,233,297.78..1,233,297.81 rows=1 width=68) (actual time=187,947.363..187,947.363 rows=0 loops=1)

2. 0.002 187,947.362 ↓ 0.0 0 1

GroupAggregate (cost=1,233,297.78..1,233,297.81 rows=1 width=68) (actual time=187,947.362..187,947.362 rows=0 loops=1)

  • Group Key: juliet.quebec
3. 0.018 187,947.360 ↓ 0.0 0 1

Sort (cost=1,233,297.78..1,233,297.79 rows=1 width=212) (actual time=187,947.360..187,947.360 rows=0 loops=1)

  • Sort Key: juliet.quebec
  • Sort Method: quicksort Memory: 25kB
4. 0.000 187,947.342 ↓ 0.0 0 1

Nested Loop Anti Join (cost=1,002.83..1,233,297.77 rows=1 width=212) (actual time=187,947.342..187,947.342 rows=0 loops=1)

  • Join Filter: (delta."romeo" = juliet.quebec)
5. 0.000 187,947.342 ↓ 0.0 0 1

Nested Loop Anti Join (cost=1,002.83..1,211,433.47 rows=1 width=212) (actual time=187,947.342..187,947.342 rows=0 loops=1)

6. 0.001 187,947.342 ↓ 0.0 0 1

Nested Loop (cost=1,002.26..1,211,425.99 rows=1 width=212) (actual time=187,947.342..187,947.342 rows=0 loops=1)

7. 169.802 187,947.341 ↓ 0.0 0 1

Nested Loop (cost=1,001.70..1,211,404.98 rows=1 width=113) (actual time=187,947.341..187,947.341 rows=0 loops=1)

8. 0.000 1,333.715 ↓ 48,477.3 290,864 1

Gather (cost=1,001.13..1,211,368.92 rows=6 width=12) (actual time=4.400..1,333.715 rows=290,864 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
9. 92.112 44,928.056 ↓ 48,477.5 96,955 3 / 3

Nested Loop (cost=1.13..1,210,368.32 rows=2 width=12) (actual time=2.515..44,928.056 rows=96,955 loops=3)

10. 24.443 28,219.988 ↓ 1,313.1 97,169 3 / 3

Nested Loop (cost=0.57..1,210,070.44 rows=74 width=8) (actual time=2.255..28,219.988 rows=97,169 loops=3)

11. 8,761.678 8,761.678 ↓ 58.7 97,169 3 / 3

Parallel Seq Scan on alpha_two foxtrot_hotel (cost=0.00..1,195,894.80 rows=1,655 width=4) (actual time=1.425..8,761.678 rows=97,169 loops=3)

  • Filter: (((foxtrot_quebec)::text = 'five'::text) AND (("six")::text = 'india'::text))
  • Rows Removed by Filter: 18,440,699
12. 19,433.867 19,433.867 ↑ 1.0 1 291,508 / 3

Index Scan using victor on juliet (cost=0.57..8.57 rows=1 width=4) (actual time=0.200..0.200 rows=1 loops=291,508)

  • Index Cond: (quebec = seven_lima2."romeo")
  • Filter: (("sierra_echo")::text = 'alpha_bravo'::text)
13. 16,615.956 16,615.956 ↑ 1.0 1 291,508 / 3

Index Only Scan using bravo on alpha_two mike (cost=0.56..4.03 rows=1 width=4) (actual time=0.171..0.171 rows=1 loops=291,508)

  • Index Cond: (("romeo" = juliet.quebec) AND (foxtrot_quebec = 'lima_six'::text))
  • Heap Fetches: 143,287
14. 186,443.824 186,443.824 ↓ 0.0 0 290,864

Index Scan using oscar on seven_delta lima_delta (cost=0.56..6.01 rows=1 width=101) (actual time=0.641..0.641 rows=0 loops=290,864)

  • Index Cond: (("romeo" = juliet.quebec) AND ((november)::text = 'zulu_four'::text))
  • Filter: (((zulu_golf())::date = (("seven_five" + 'hotel_sierra'::interval uniform))::date) AND ("yankee" = ANY ('sierra_victor'::integer[])))
  • Rows Removed by Filter: 1
15. 0.000 0.000 ↓ 0.0 0

Index Scan using bravo on alpha_two (cost=0.56..20.89 rows=12 width=115) (never executed)

  • Index Cond: ("romeo" = juliet.quebec)
16. 0.000 0.000 ↓ 0.0 0

Index Only Scan using bravo on alpha_two hotel_november (cost=0.56..4.03 rows=1 width=4) (never executed)

  • Index Cond: (("romeo" = juliet.quebec) AND (foxtrot_quebec = 'echo'::text))
  • Heap Fetches: 0
17. 0.000 0.000 ↓ 0.0 0

Seq Scan on lima_echo delta (cost=0.00..21,498.79 rows=29,241 width=4) (never executed)

  • Filter: ("seven_oscar" = 1,465)
Planning time : 10.460 ms
Execution time : 187,948.330 ms