explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5xti : Optimization for: Optimization for: Optimization for: Optimization for: plan #fqp6; plan #GN2U; plan #DKQp; plan #84Or

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 14.065 230.419 ↑ 7.2 65 1

Gather (cost=11,570.63..50,104.57 rows=466 width=8) (actual time=168.899..230.419 rows=65 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 0.050 216.354 ↑ 8.9 13 5

Nested Loop (cost=10,570.63..49,057.97 rows=116 width=8) (actual time=185.481..216.354 rows=13 loops=5)

3. 44.185 216.301 ↑ 8.9 13 5

Hash Left Join (cost=10,570.48..49,037.65 rows=116 width=8) (actual time=185.466..216.301 rows=13 loops=5)

  • Hash Cond: (slr_payment_type.dict_root_id = slr_dict_root.id)
  • Filter: ((slr_dict_root.ent_id = 8018) OR (slr_dict_root.ent_id IS NULL))
  • Rows Removed by Filter: 61480
4. 26.081 26.081 ↑ 1.3 61,493 5

Parallel Seq Scan on slr_payment_type (cost=0.00..37,210.40 rows=77,340 width=8) (actual time=0.007..26.081 rows=61,493 loops=5)

  • Filter: (payment_type_template_id IS NOT NULL)
5. 92.351 146.035 ↑ 1.0 352,253 5

Hash (cost=6,161.88..6,161.88 rows=352,688 width=8) (actual time=146.035..146.035 rows=352,253 loops=5)

  • Buckets: 524288 Batches: 1 Memory Usage: 17854kB
6. 53.684 53.684 ↑ 1.0 352,253 5

Seq Scan on slr_dict_root (cost=0.00..6,161.88 rows=352,688 width=8) (actual time=0.021..53.684 rows=352,253 loops=5)

7. 0.003 0.003 ↑ 1.0 1 65

Index Scan using slr_payment_type_template_pkey on slr_payment_type_template (cost=0.15..0.17 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=65)

  • Index Cond: (id = slr_payment_type.payment_type_template_id)