explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6EuQ

Settings
# exclusive inclusive rows x rows loops node
1. 14.042 206.512 ↑ 1.2 56 1

Gather (cost=11,456.81..49,559.88 rows=68 width=8) (actual time=154.349..206.512 rows=56 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
2. 0.055 192.470 ↑ 1.5 11 5

Nested Loop (cost=10,456.81..48,553.08 rows=17 width=8) (actual time=144.513..192.470 rows=11 loops=5)

3. 40.493 192.412 ↑ 1.5 11 5

Hash Left Join (cost=10,456.66..48,550.10 rows=17 width=8) (actual time=144.499..192.412 rows=11 loops=5)

  • Hash Cond: (slr_payment_type.dict_root_id = slr_dict_root.id)
  • Filter: ((slr_dict_root.ent_id = 1974) OR slr_payment_type.is_from_cloud)
  • Rows Removed by Filter: 60822
4. 21.958 21.958 ↑ 1.3 60,833 5

Parallel Seq Scan on slr_payment_type (cost=0.00..36,848.89 rows=76,588 width=9) (actual time=0.007..21.958 rows=60,833 loops=5)

  • Filter: (payment_type_template_id IS NOT NULL)
5. 82.589 129.961 ↑ 1.0 348,539 5

Hash (cost=6,094.07..6,094.07 rows=349,007 width=8) (actual time=129.961..129.961 rows=348,539 loops=5)

  • Buckets: 524288 Batches: 1 Memory Usage: 17709kB
6. 47.372 47.372 ↑ 1.0 348,539 5

Seq Scan on slr_dict_root (cost=0.00..6,094.07 rows=349,007 width=8) (actual time=0.017..47.372 rows=348,539 loops=5)

7. 0.003 0.003 ↑ 1.0 1 56

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=56)

  • Index Cond: (id = slr_payment_type.payment_type_template_id)