explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hBnK

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Aggregate (cost=446,624.43..446,624.44 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=304,320.45..443,320.63 rows=1,321,521 width=0) (actual rows= loops=)

  • Hash Cond: (t2.pac_header_id = t3.po_header_id)
3. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=269,477.90..385,254.42 rows=1,321,521 width=6) (actual rows= loops=)

  • Hash Cond: (t2.mail_attachment_id = t1.mail_attachment_id)
4. 0.000 0.000 ↓ 0.0

Seq Scan on escan_pac_header_t t2 (cost=0.00..85,947.38 rows=1,430,338 width=12) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=247,795.88..247,795.88 rows=1,321,521 width=6) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash Join (cost=97,630.19..247,795.88 rows=1,321,521 width=6) (actual rows= loops=)

  • Hash Cond: ((t.receive)::text = (t4.receive_mail)::text)
7. 0.000 0.000 ↓ 0.0

Hash Right Join (cost=97,527.74..244,174.43 rows=1,321,521 width=28) (actual rows= loops=)

  • Hash Cond: (t1.mail_info_id = t.mail_info_id)
8. 0.000 0.000 ↓ 0.0

Seq Scan on escan_mail_attachment_t t1 (cost=0.00..98,089.74 rows=3,543,974 width=12) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash (cost=84,392.81..84,392.81 rows=679,274 width=28) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Seq Scan on escan_mail_info_t t (cost=0.00..84,392.81 rows=679,274 width=28) (actual rows= loops=)

  • Filter: ((business_type)::text = '2'::text)
11. 0.000 0.000 ↓ 0.0

Hash (cost=98.78..98.78 rows=294 width=22) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

HashAggregate (cost=92.90..95.84 rows=294 width=22) (actual rows= loops=)

  • Group Key: t4.receive_mail
13. 0.000 0.000 ↓ 0.0

Hash Join (cost=71.13..91.12 rows=712 width=22) (actual rows= loops=)

  • Hash Cond: (t4.customer_id = t5.customer_id)
14. 0.000 0.000 ↓ 0.0

Seq Scan on escan_template_relation_t t4 (cost=0.00..18.12 rows=712 width=27) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Hash (cost=49.39..49.39 rows=1,739 width=5) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

Seq Scan on escan_auto_parse_customer_t t5 (cost=0.00..49.39 rows=1,739 width=5) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

Hash (cost=24,930.58..24,930.58 rows=604,158 width=6) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Seq Scan on escan_po_error_t t3 (cost=0.00..24,930.58 rows=604,158 width=6) (actual rows= loops=)