explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aZgf

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 9,135.595 ↓ 5.0 5 1

Limit (cost=38.510..38.520 rows=1 width=72) (actual time=9,135.594..9,135.595 rows=5 loops=1)

2. 0.010 9,135.594 ↓ 5.0 5 1

Sort (cost=38.510..38.520 rows=1 width=72) (actual time=9,135.594..9,135.594 rows=5 loops=1)

  • Sort Key: juliet1.romeo
  • Sort Method: quicksort Memory: 26kB
3. 0.013 9,135.584 ↓ 5.0 5 1

Subquery Scan on kilo (cost=25.000..38.500 rows=1 width=72) (actual time=9,135.522..9,135.584 rows=5 loops=1)

  • Filter: (november(juliet1.quebec, 1) = november((delta 1), 1))
4. 0.048 9,135.511 ↑ 40.0 5 1

HashAggregate (cost=25.000..29.500 rows=200 width=20) (actual time=9,135.503..9,135.511 rows=5 loops=1)

5. 9,135.463 9,135.463 ↑ 18.9 53 1

Function Scan on echo (cost=0.000..10.000 rows=1,000 width=20) (actual time=9,135.461..9,135.463 rows=53 loops=1)

6.          

SubPlan (forSubquery Scan)

7. 0.045 0.060 ↓ 10.0 10 5

HashAggregate (cost=0.020..0.030 rows=1 width=0) (actual time=0.011..0.012 rows=10 loops=5)

8. 0.015 0.015 ↓ 10.0 10 5

Result (cost=0.000..0.010 rows=1 width=0) (actual time=0.002..0.003 rows=10 loops=5)