explain.depesz.com

PostgreSQL's explain analyze made readable

Result: io5N

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

Index Scan using pk_slrorderline on slrorderline x (cost=0.31..19.16 rows=1 width=79) (actual time=23.865..23.865 rows=0 loops=1)

  • Index Cond: (id = '1003'::numeric)
  • Filter: ($0 AND (alternatives: SubPlan 3 or hashed SubPlan 5))
2.          

Initplan (for Index Scan)

3. 0.000 0.000 ↓ 0.0 0

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

4.          

SubPlan (for Index Scan)

5. 0.000 0.000 ↓ 0.0 0

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

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

Initplan (for Index Scan)

7. 0.000 0.000 ↓ 0.0 0

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

8. 0.000 0.000 ↓ 0.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: (idliabilitygroup = ANY (adm_pfunc.getaccess(SESSION_USER)))
  • Filter: $4
9.          

Initplan (for Index Scan)

10. 0.000 0.000 ↓ 0.0 0

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

Planning time : 1.151 ms