explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3go6

Settings
# exclusive inclusive rows x rows loops node
1. 339.156 1,105.434 ↑ 1.0 52,584 1

Hash Left Join (cost=3,721.29..6,382.43 rows=52,645 width=60) (actual time=203.637..1,105.434 rows=52,584 loops=1)

  • Hash Cond: (i."VariableTypeId" = v."Id")
2. 364.403 766.228 ↑ 1.0 52,584 1

Hash Right Join (cost=3,720.18..5,657.44 rows=52,645 width=62) (actual time=203.548..766.228 rows=52,584 loops=1)

  • Hash Cond: (i."AutomatonRuleId" = a."Id")
3. 198.759 198.759 ↓ 1.0 57,811 1

Seq Scan on "InVariables" i (cost=0.00..1,194.05 rows=57,805 width=54) (actual time=0.007..198.759 rows=57,811 loops=1)

4. 86.717 203.066 ↑ 1.0 26,292 1

Hash (cost=3,391.03..3,391.03 rows=26,332 width=16) (actual time=203.066..203.066 rows=26,292 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1489kB
5. 116.349 116.349 ↑ 1.0 26,292 1

Seq Scan on "AutomatonRules" a (cost=0.00..3,391.03 rows=26,332 width=16) (actual time=0.035..116.349 rows=26,292 loops=1)

  • Filter: (("TemplateId" IS NOT NULL) AND (("Type")::text = 'SyntheticTrigger'::text) AND ("UserspaceId" = 1) AND ("OwnerWorkGroupId" = ANY ('{23,419,428}'::bigint[])))
  • Rows Removed by Filter: 2619
6. 0.032 0.050 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=14) (actual time=0.050..0.050 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.018 0.018 ↑ 1.0 5 1

Seq Scan on "VariableTypes" v (cost=0.00..1.05 rows=5 width=14) (actual time=0.005..0.018 rows=5 loops=1)

Planning time : 0.704 ms
Execution time : 1,265.128 ms