explain.depesz.com

PostgreSQL's explain analyze made readable

Result: zp1

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.053 ↑ 1.0 1 1

Result (cost=1.09..1.10 rows=1 width=32) (actual time=0.053..0.053 rows=1 loops=1)

2.          

CTE __local_0__

3. 0.009 0.040 ↑ 1.0 1 1

Sort (cost=1.03..1.03 rows=1 width=48) (actual time=0.040..0.040 rows=1 loops=1)

  • Sort Key: __local_1__.user_id
  • Sort Method: quicksort Memory: 25kB
4. 0.031 0.031 ↑ 1.0 1 1

Seq Scan on card_order __local_1__ (cost=0.00..1.02 rows=1 width=48) (actual time=0.030..0.031 rows=1 loops=1)

5.          

CTE __local_2__

6. 0.005 0.050 ↑ 1.0 1 1

Aggregate (cost=0.03..0.04 rows=1 width=32) (actual time=0.050..0.050 rows=1 loops=1)

7. 0.045 0.045 ↑ 1.0 1 1

CTE Scan on __local_0__ (cost=0.00..0.02 rows=1 width=24) (actual time=0.044..0.045 rows=1 loops=1)

8.          

Initplan (forResult)

9. 0.051 0.051 ↑ 1.0 1 1

CTE Scan on __local_2__ (cost=0.00..0.02 rows=1 width=32) (actual time=0.051..0.051 rows=1 loops=1)