explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 0Pl

Settings
# exclusive inclusive rows x rows loops node
1. 0.247 61.029 ↑ 1.0 1 1

Result (cost=84,025.94..84,025.95 rows=1 width=32) (actual time=61.028..61.029 rows=1 loops=1)

2.          

CTE __local_0__

3. 0.816 49.168 ↑ 1.0 10,000 1

Limit (cost=0.42..83,775.90 rows=10,000 width=36) (actual time=0.051..49.168 rows=10,000 loops=1)

4. 28.352 48.352 ↑ 23.1 10,000 1

Index Scan using applicationform_pkey on applicationform __local_2__ (cost=0.42..1,936,939.87 rows=231,206 width=36) (actual time=0.050..48.352 rows=10,000 loops=1)

5.          

SubPlan (forIndex Scan)

6. 20.000 20.000 ↑ 1.0 1 10,000

Index Scan using user_pkey on "user" __local_1__ (cost=0.28..8.30 rows=1 width=32) (actual time=0.002..0.002 rows=1 loops=10,000)

  • Index Cond: (__local_2__.user_id = id)
7.          

CTE __local_3__

8. 6.755 60.469 ↑ 1.0 1 1

Aggregate (cost=250.00..250.01 rows=1 width=32) (actual time=60.468..60.469 rows=1 loops=1)

9. 53.714 53.714 ↑ 1.0 10,000 1

CTE Scan on __local_0__ (cost=0.00..200.00 rows=10,000 width=24) (actual time=0.056..53.714 rows=10,000 loops=1)

10.          

Initplan (forResult)

11. 60.782 60.782 ↑ 1.0 1 1

CTE Scan on __local_3__ (cost=0.00..0.02 rows=1 width=32) (actual time=60.781..60.782 rows=1 loops=1)

Planning time : 0.307 ms
Execution time : 61.275 ms