explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rb5C

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.120 1,067.799 ↑ 10.9 68 1

Hash Join (cost=13,878.58..68,715.53 rows=743 width=8) (actual time=312.450..1,067.799 rows=68 loops=1)

  • Hash Cond: (slr_payment_type.payment_type_template_id = slr_payment_type_template.id)
2. 372.804 1,066.593 ↑ 10.9 68 1

Hash Left Join (cost=13,821.83..68,648.56 rows=743 width=8) (actual time=311.334..1,066.593 rows=68 loops=1)

  • Hash Cond: (slr_payment_type.dict_root_id = slr_dict_root.id)
  • Filter: ((slr_dict_root.ent_id = 7967) OR (slr_dict_root.ent_id IS NULL))
  • Rows Removed by Filter: 403964
3. 389.850 389.850 ↓ 1.0 404,032 1

Seq Scan on slr_payment_type (cost=0.00..48,267.47 rows=403,647 width=8) (actual time=0.034..389.850 rows=404,032 loops=1)

  • Filter: (payment_type_template_id IS NOT NULL)
4. 169.243 303.939 ↓ 1.0 462,979 1

Hash (cost=8,034.70..8,034.70 rows=462,970 width=8) (actual time=303.939..303.939 rows=462,979 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 22180kB
5. 134.696 134.696 ↓ 1.0 462,979 1

Seq Scan on slr_dict_root (cost=0.00..8,034.70 rows=462,970 width=8) (actual time=0.024..134.696 rows=462,979 loops=1)

6. 0.146 1.086 ↑ 1.0 389 1

Hash (cost=51.89..51.89 rows=389 width=8) (actual time=1.086..1.086 rows=389 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
7. 0.940 0.940 ↑ 1.0 389 1

Seq Scan on slr_payment_type_template (cost=0.00..51.89 rows=389 width=8) (actual time=0.032..0.940 rows=389 loops=1)

Planning time : 1.324 ms
Execution time : 1,068.043 ms