explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 80LG : Optimization for: plan #KZUm

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 2.159 2.159 ↑ 1.0 2,195 1

HashAggregate (cost=74725.71..74732.23 rows=652 width=46) (actual time=3491.712..3492.188 rows=2195 loops=1)Group Key: classb.pyrulesetname, classb.pyrulesetversionid, classb.pyversionsecure-> Nested Loop Left Join (cost=0.42..69212.19 rows=441082 width=123) (actual time=0.040..3375.333 rows=409842 loops=1)-> Seq Scan on pr4_rule_ruleset classb (cost=0.00..566.25 rows=2,195 width=30) (actual time=0.012..2.159 rows=2,195 loops=1)

Planning time : 0.949 ms
Execution time : 3,492.311 ms