explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xI1j

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 0.696 ↓ 14.0 14 1

Nested Loop (cost=295.10..518.59 rows=1 width=16) (actual time=0.145..0.696 rows=14 loops=1)

2.          

CTE foxtrot_delta

3. 0.109 0.109 ↑ 1.4 14 1

Index Scan using quebec_three_oscar on two quebec_sierra (cost=0.43..80.81 rows=19 width=4) (actual time=0.084..0.109 rows=14 loops=1)

  • Index Cond: ((zulu_lima = 164,772) AND (seven && foxtrot_six((zulu_golf() - 'foxtrot_papa'::interval), zulu_golf())))
4.          

CTE romeo

5. 0.009 0.562 ↑ 1.9 14 1

Nested Loop (cost=1.70..213.72 rows=26 width=8) (actual time=0.132..0.562 rows=14 loops=1)

6. 0.028 0.441 ↑ 1.9 14 1

Nested Loop (cost=1.13..196.30 rows=26 width=12) (actual time=0.121..0.441 rows=14 loops=1)

7. 0.024 0.269 ↑ 2.0 24 1

Nested Loop (cost=0.57..164.76 rows=48 width=8) (actual time=0.100..0.269 rows=24 loops=1)

8. 0.119 0.119 ↑ 1.4 14 1

CTE Scan on foxtrot_delta zulu_zulu (cost=0.00..0.38 rows=19 width=4) (actual time=0.085..0.119 rows=14 loops=1)

9. 0.126 0.126 ↑ 1.5 2 14

Index Scan using quebec_juliet on uniform_kilo delta (cost=0.57..8.62 rows=3 width=8) (actual time=0.008..0.009 rows=2 loops=14)

  • Index Cond: (victor_five = golf1.quebec_seven)
10. 0.144 0.144 ↑ 1.0 1 24

Index Scan using yankee_echo on india six_charlie_uniform (cost=0.56..0.66 rows=1 width=4) (actual time=0.006..0.006 rows=1 loops=24)

  • Index Cond: (echo = delta.echo)
  • Filter: ((NOT four) AND tango)
  • Rows Removed by Filter: 0
11. 0.112 0.112 ↑ 1.0 1 14

Index Scan using yankee_juliet on alpha_uniform quebec_three_three (cost=0.57..0.67 rows=1 width=4) (actual time=0.008..0.008 rows=1 loops=14)

  • Index Cond: (quebec_seven = delta.echo)
  • Filter: (victor_juliet = 'november'::yankee_alpha)
12. 0.571 0.571 ↑ 1.9 14 1

CTE Scan on romeo uniform_delta (cost=0.00..0.52 rows=26 width=8) (actual time=0.133..0.571 rows=14 loops=1)

13. 0.112 0.112 ↑ 1.0 1 14

Index Scan using alpha_three on whiskey juliet (cost=0.56..8.59 rows=1 width=24) (actual time=0.008..0.008 rows=1 loops=14)

  • Index Cond: (victor_five = uniform_delta.victor_five)
  • Filter: ((victor_juliet = 'november'::yankee_alpha) AND (uniform_delta.six_charlie_india = six_charlie_india))
  • Rows Removed by Filter: 0
Planning time : 1.790 ms
Execution time : 0.777 ms