explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OiJI

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Result (cost=3.93..4.39 rows=23 width=4) (actual rows= loops=)

  • One-Time Filter: ($1 AND $2 AND $3)
2.          

CTE regapp

3. 0.000 0.000 ↓ 0.0

Seq Scan on rm_renders_registred_app (cost=0.00..2.38 rows=23 width=8) (actual rows= loops=)

  • Filter: (instance_id = 5)
4.          

Initplan (forResult)

5. 0.000 0.000 ↓ 0.0

CTE Scan on regapp regapp_1 (cost=0.00..0.52 rows=1 width=0) (actual rows= loops=)

  • Filter: (app_id = 1)
6. 0.000 0.000 ↓ 0.0

CTE Scan on regapp regapp_2 (cost=0.00..0.52 rows=1 width=0) (actual rows= loops=)

  • Filter: (app_id = 1)
7. 0.000 0.000 ↓ 0.0

CTE Scan on regapp regapp_3 (cost=0.00..0.52 rows=1 width=0) (actual rows= loops=)

  • Filter: (app_id = 1)
8. 0.000 0.000 ↓ 0.0

CTE Scan on regapp (cost=3.93..4.39 rows=23 width=4) (actual rows= loops=)