explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fqp6

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 12.325 263.417 ↑ 1.0 65 1

Gather (cost=11,550.58..49,968.93 rows=66 width=8) (actual time=246.374..263.417 rows=65 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 0.053 251.092 ↑ 1.2 13 5

Nested Loop (cost=10,550.58..48,962.33 rows=16 width=8) (actual time=222.486..251.092 rows=13 loops=5)

3. 45.022 251.036 ↑ 1.2 13 5

Hash Left Join (cost=10,550.43..48,959.53 rows=16 width=8) (actual time=222.472..251.036 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_payment_type.is_from_cloud)
  • Rows Removed by Filter: 61380
4. 25.058 25.058 ↑ 1.3 61,393 5

Parallel Seq Scan on slr_payment_type (cost=0.00..37,154.23 rows=77,223 width=9) (actual time=0.014..25.058 rows=61,393 loops=5)

  • Filter: (payment_type_template_id IS NOT NULL)
5. 111.308 180.956 ↑ 1.0 351,703 5

Hash (cost=6,150.19..6,150.19 rows=352,019 width=8) (actual time=180.956..180.956 rows=351,703 loops=5)

  • Buckets: 524288 Batches: 1 Memory Usage: 17833kB
6. 69.648 69.648 ↑ 1.0 351,703 5

Seq Scan on slr_dict_root (cost=0.00..6,150.19 rows=352,019 width=8) (actual time=0.022..69.648 rows=351,703 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)