explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w4sKv

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

Seq Scan on slrorderline x (cost=0.02..148,532.67 rows=3,420 width=79) (never executed)

  • Filter: ($0 AND (alternatives: SubPlan 3 or hashed SubPlan 5))
2.          

Initplan (for Seq Scan)

3. 0.000 0.000 ↓ 0.0

Result (cost=0..0.02 rows=1 width=1) (never executed)

4.          

SubPlan (for Seq Scan)

5. 0.000 0.000 ↓ 0.0

Index Scan using pk_slrorder on slrorder slrorder (cost=0.31..10.84 rows=1 width=0) (never executed)

  • Index Cond: (slrorder.id = x.idorder)
  • Filter: ($2 AND (slrorder.idliabilitygroup = ANY (adm_pfunc.getaccess(SESSION_USER))))
6.          

Initplan (for Index Scan)

7. 0.000 0.000 ↓ 0.0

Result (cost=0..0.02 rows=1 width=1) (never executed)

8. 0.000 0.000 ↓ 0.0

Index Scan using fk_slrorder_liabilitygroup on slrorder slrorder_1 (cost=2.81..672.79 rows=6,727 width=8) (never executed)

  • Index Cond: (slrorder_1.idliabilitygroup = ANY (adm_pfunc.getaccess(SESSION_USER)))
  • Filter: $4
9.          

Initplan (for Index Scan)

10. 0.000 0.000 ↓ 0.0

Result (cost=0..0.02 rows=1 width=1) (never executed)

Planning time : 0.982 ms