explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5scu

Settings
# exclusive inclusive rows x rows loops node
1. 470.686 798.862 ↓ 4.0 13,681 1

Seq Scan on slrorderline x (cost=0.02..148,532.67 rows=3,420 width=79) (actual time=333.679..798.862 rows=13,681 loops=1)

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

Initplan (for Seq Scan)

3. 0.208 0.208 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=1) (actual time=0.207..0.208 rows=1 loops=1)

4.          

SubPlan (for Seq 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. 327.788 327.968 ↓ 2.0 13,454 1

Index Scan using fk_slrorder_liabilitygroup on slrorder slrorder_1 (cost=2.81..672.79 rows=6,727 width=8) (actual time=0.233..327.968 rows=13,454 loops=1)

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

Initplan (for Index Scan)

10. 0.180 0.180 ↑ 1.0 1 1

Result (cost=0.00..0.02 rows=1 width=1) (actual time=0.180..0.180 rows=1 loops=1)

Planning time : 0.989 ms