explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uG4r : Query DrillDown

Settings
# exclusive inclusive rows x rows loops node
1. 0.026 5.674 ↓ 1.3 51 1

GroupAggregate (cost=517.090..520.320 rows=38 width=96) (actual time=5.582..5.674 rows=51 loops=1)

  • Group Key: lima_delta.three_zulu, (('lima_uniform'::text || (($2 - (delta 4)))::text)), (echo('quebec_echo'::text, zulu.alpha_oscar)), ((zulu.alpha_oscar)::date)
2.          

Initplan (for GroupAggregate)

3. 0.021 0.021 ↑ 1.0 1 1

Result (cost=0.000..0.040 rows=1 width=8) (actual time=0.021..0.021 rows=1 loops=1)

4. 0.009 0.009 ↑ 1.0 1 1

Result (cost=0.000..0.040 rows=1 width=8) (actual time=0.009..0.009 rows=1 loops=1)

5. 0.019 0.019 ↑ 1.0 1 1

Result (cost=0.000..0.040 rows=1 width=8) (actual time=0.019..0.019 rows=1 loops=1)

6. 0.266 5.548 ↓ 4.8 182 1

Sort (cost=516.960..517.060 rows=38 width=88) (actual time=5.533..5.548 rows=182 loops=1)

  • Sort Key: lima_delta.three_zulu, (('lima_uniform'::text || (($2 - (delta 4)))::text)), (echo('quebec_echo'::text, zulu.alpha_oscar)), ((zulu.alpha_oscar)::date)
  • Sort Method: quicksort Memory: 50kB
7. 0.222 5.282 ↓ 4.8 182 1

Nested Loop (cost=1.610..515.970 rows=38 width=88) (actual time=0.125..5.282 rows=182 loops=1)

  • Join Filter: (alpha_bravo.xray = lima_delta.quebec_seven)
8. 0.158 4.696 ↓ 4.8 182 1

Hash Join (cost=1.470..507.640 rows=38 width=32) (actual time=0.091..4.696 rows=182 loops=1)

  • Hash Cond: (zulu.xray = alpha_bravo.xray)
9. 4.522 4.522 ↑ 1.9 752 1

Seq Scan on zulu (cost=0.000..500.450 rows=1,423 width=24) (actual time=0.054..4.522 rows=752 loops=1)

  • Filter: ((delta 5) <= $5)
  • Rows Removed by Filter: 3,667
10.          

SubPlan (for Seq Scan)

11. 0.000 0.000 ↑ 1.0 1 4,419

Result (cost=0.000..0.020 rows=1 width=8) (actual time=0.000..0.000 rows=1 loops=4,419)

12. 0.003 0.016 ↑ 1.0 1 1

Hash (cost=1.460..1.460 rows=1 width=8) (actual time=0.016..0.016 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
13. 0.013 0.013 ↑ 1.0 1 1

Seq Scan on three_two alpha_bravo (cost=0.000..1.460 rows=1 width=8) (actual time=0.010..0.013 rows=1 loops=1)

  • Filter: (lima_five = 157)
  • Rows Removed by Filter: 50
14. 0.182 0.182 ↑ 1.0 1 182

Index Scan using sierra_bravo on sierra_quebec lima_delta (cost=0.140..0.170 rows=1 width=36) (actual time=0.001..0.001 rows=1 loops=182)

  • Index Cond: (quebec_seven = zulu.xray)
15.          

SubPlan (for Nested Loop)

16. 0.182 0.182 ↑ 1.0 1 182

Result (cost=0.000..0.020 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=182)

17.          

SubPlan (for GroupAggregate)

18. 0.051 0.051 ↑ 1.0 1 51

Result (cost=0.000..0.020 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=51)

Planning time : 0.822 ms
Execution time : 6.002 ms