explain.depesz.com

PostgreSQL's explain analyze made readable

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

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.072 488.146 ↑ 1.0 65 1

Nested Loop (cost=10,175.97..48,737.34 rows=68 width=8) (actual time=206.092..488.146 rows=65 loops=1)

2. 224.413 487.814 ↑ 1.0 65 1

Hash Left Join (cost=10,175.70..48,716.89 rows=68 width=8) (actual time=206.059..487.814 rows=65 loops=1)

  • Hash Cond: (slr_payment_type.dict_root_id = slr_dict_root.id)
  • Filter: ((slr_dict_root.ent_id = ANY ('{8018,NULL}'::integer[])) OR slr_payment_type.is_from_cloud)
  • Rows Removed by Filter: 297670
3. 132.114 132.114 ↑ 1.0 297,735 1

Seq Scan on slr_payment_type (cost=0.00..33,701.36 rows=297,836 width=9) (actual time=0.009..132.114 rows=297,735 loops=1)

  • Filter: (payment_type_template_id IS NOT NULL)
4. 80.103 131.287 ↓ 1.0 340,832 1

Hash (cost=5,915.31..5,915.31 rows=340,831 width=8) (actual time=131.286..131.287 rows=340,832 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 17408kB
5. 51.184 51.184 ↓ 1.0 340,832 1

Seq Scan on slr_dict_root (cost=0.00..5,915.31 rows=340,831 width=8) (actual time=0.011..51.184 rows=340,832 loops=1)

6. 0.260 0.260 ↑ 1.0 1 65

Index Scan using slr_payment_type_template_pkey on slr_payment_type_template (cost=0.27..0.29 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=65)

  • Index Cond: (id = slr_payment_type.payment_type_template_id)