explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IarP

Settings
# exclusive inclusive rows x rows loops node
1. 205.051 50,049.361 ↓ 1.5 106 1

Gather (cost=16,632.63..129,079.22 rows=73 width=861) (actual time=771.472..50,049.361 rows=106 loops=1)

  • Workers Planned: 4
  • Workers Launched: 0
2. 40,320.708 49,842.384 ↓ 5.9 106 1

Nested Loop Left Join (cost=15,632.63..127,101.43 rows=18 width=797) (actual time=769.292..49,842.384 rows=106 loops=1)

  • Filter: (((slr_dict_root.ent_id = 2882) AND (slr_payment_type_template.algorithm_group <> 5) AND (NOT slr_payment_type_template.hidden) AND ((NOT slr_united_dict.hidden) OR (slr_united_dict.id IS NULL))) OR slr_payment_type.is_from_cloud)
  • Rows Removed by Filter: 396812
3. 719.625 9,521.575 ↓ 5.7 396,918 1

Hash Left Join (cost=15,632.21..72,805.15 rows=69,461 width=808) (actual time=429.002..9,521.575 rows=396,918 loops=1)

  • Hash Cond: (slr_payment_type.dict_root_id = slr_dict_root.id)
4. 920.063 8,375.370 ↓ 5.7 396,918 1

Hash Join (cost=104.55..56,322.41 rows=69,461 width=800) (actual time=1.724..8,375.370 rows=396,918 loops=1)

  • Hash Cond: (slr_payment_type.payment_type_template_id = slr_payment_type_template.id)
5. 7,453.603 7,453.603 ↓ 3.9 418,322 1

Parallel Seq Scan on slr_payment_type (cost=0.00..55,117.36 rows=108,236 width=797) (actual time=0.004..7,453.603 rows=418,322 loops=1)

6. 0.106 1.704 ↓ 1.5 377 1

Hash (cost=101.44..101.44 rows=249 width=7) (actual time=1.704..1.704 rows=377 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
7. 1.598 1.598 ↓ 1.5 377 1

Seq Scan on slr_payment_type_template (cost=0.00..101.44 rows=249 width=7) (actual time=0.012..1.598 rows=377 loops=1)

  • Filter: ((algorithm_group = ANY ('{1,2,3}'::integer[])) AND ((algorithm_code)::text = ANY ('{PedagogicalStaffSpecificityNSOT,WorkIntensityAllowanceSum,ServiceInProfileAllowance,ManagingStructuralNSOT,WrittenWorkPayment,Summa (...)
  • Rows Removed by Filter: 14
8. 143.857 426.580 ↑ 1.1 479,687 1

Hash (cost=9,226.18..9,226.18 rows=504,118 width=8) (actual time=426.580..426.580 rows=479,687 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 22832kB
9. 282.723 282.723 ↑ 1.1 479,687 1

Seq Scan on slr_dict_root (cost=0.00..9,226.18 rows=504,118 width=8) (actual time=0.007..282.723 rows=479,687 loops=1)

10. 0.101 0.101 ↑ 9.0 1 396,918

Index Scan using slr_united_dict_dict_root_id on slr_united_dict (cost=0.42..0.65 rows=9 width=9) (actual time=0.100..0.101 rows=1 loops=396,918)

  • Index Cond: (slr_dict_root.id = dict_root_id)
11.          

SubPlan (forGather)

12. 0.022 1.266 ↑ 1.0 1 106

Aggregate (cost=8.12..8.13 rows=1 width=32) (actual time=1.266..1.266 rows=1 loops=106)

13. 0.401 1.244 ↑ 1.0 2 106

Nested Loop (cost=0.71..8.11 rows=2 width=17) (actual time=1.237..1.244 rows=2 loops=106)

14. 0.306 0.306 ↑ 1.0 2 106

Index Scan using slr_payment_type_group_rec_payment_type_id on slr_payment_type_group_rec gr (cost=0.42..3.08 rows=2 width=4) (actual time=0.305..0.306 rows=2 loops=106)

  • Index Cond: (payment_type_id = slr_payment_type.id)
15. 0.537 0.537 ↑ 1.0 1 184

Index Scan using slr_payment_type_group_pkey on slr_payment_type_group g (cost=0.29..2.51 rows=1 width=21) (actual time=0.537..0.537 rows=1 loops=184)

  • Index Cond: (id = gr.payment_type_group_id)
16. 0.008 0.660 ↑ 1.0 1 106

Aggregate (cost=5.16..5.17 rows=1 width=32) (actual time=0.660..0.660 rows=1 loops=106)

17. 0.000 0.652 ↓ 0.0 0 106

Nested Loop (cost=0.71..5.15 rows=1 width=17) (actual time=0.651..0.652 rows=0 loops=106)

18. 0.522 0.522 ↓ 0.0 0 106

Index Scan using slr_payment_used_group_payment_type_id on slr_payment_used_group ug (cost=0.42..2.64 rows=1 width=4) (actual time=0.522..0.522 rows=0 loops=106)

  • Index Cond: (payment_type_id = slr_payment_type.id)
19. 0.299 0.299 ↑ 1.0 1 45

Index Scan using slr_payment_type_group_pkey on slr_payment_type_group g_1 (cost=0.29..2.51 rows=1 width=21) (actual time=0.299..0.299 rows=1 loops=45)

  • Index Cond: (id = ug.payment_group_id)