explain.depesz.com

PostgreSQL's explain analyze made readable

Result: whEg : Optimization for: plan #sc5C

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 7.791 102.954 ↓ 3.0 37,661 1

Hash Join (cost=2.59..9,060.20 rows=12,554 width=112) (actual time=0.079..102.954 rows=37,661 loops=1)

  • Hash Cond: (a.analytics_work_unit_type_id = b.id)
2. 10.329 95.132 ↓ 3.0 37,661 1

Merge Left Join (cost=1.16..8,635.07 rows=12,554 width=84) (actual time=0.041..95.132 rows=37,661 loops=1)

  • Merge Cond: (a.id = e.analytics_work_unit_id)
3. 11.954 75.709 ↓ 3.0 37,661 1

Merge Left Join (cost=0.87..6,830.90 rows=12,554 width=76) (actual time=0.034..75.709 rows=37,661 loops=1)

  • Merge Cond: (a.id = c.analytics_work_unit_id)
4. 12.792 52.553 ↓ 3.0 37,661 1

Merge Join (cost=0.58..4,575.31 rows=12,554 width=68) (actual time=0.026..52.553 rows=37,661 loops=1)

  • Merge Cond: (a.id = d.analytics_work_unit_id)
5. 18.492 18.492 ↑ 1.0 37,661 1

Index Scan using analytics_work_unit_id_pk on analytics_work_unit a (cost=0.29..2,056.43 rows=37,661 width=60) (actual time=0.008..18.492 rows=37,661 loops=1)

6. 21.269 21.269 ↓ 3.0 37,661 1

Index Scan using analytics_work_unit_ix_analytics_work_unit_id on analytics_pay_rule_work_unit_map d (cost=0.29..2,016.73 rows=12,554 width=16) (actual time=0.016..21.269 rows=37,661 loops=1)

  • Filter: (expiration_date_time >= sysdate)
7. 11.202 11.202 ↑ 1.0 37,661 1

Index Scan using analytics_work_unit_org_node_map_ix_work_unit_id on analytics_work_unit_org_node_map c (cost=0.29..1,753.42 rows=37,661 width=16) (actual time=0.007..11.202 rows=37,661 loops=1)

8. 9.094 9.094 ↑ 1.0 30,000 1

Index Scan using analytics_work_group_work_unit_map_ix_analytics_work_unit_id on analytics_work_group_work_unit_map e (cost=0.29..1,397.79 rows=30,000 width=16) (actual time=0.006..9.094 rows=30,000 loops=1)

9. 0.005 0.031 ↑ 1.0 7 1

Hash (cost=1.21..1.21 rows=7 width=36) (actual time=0.031..0.031 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
10. 0.026 0.026 ↑ 1.0 7 1

Seq Scan on analytics_work_unit_type b (cost=0.00..1.21 rows=7 width=36) (actual time=0.025..0.026 rows=7 loops=1)

Planning time : 0.697 ms
Execution time : 104.500 ms