explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3VhC

Settings
# exclusive inclusive rows x rows loops node
1. 1,700.168 20,471.809 ↑ 2.5 544,249 1

Hash Left Join (cost=143,710.05..283,334.04 rows=1,343,968 width=258) (actual time=5,465.134..20,471.809 rows=544,249 loops=1)

  • Hash Cond: ((w_inlink.vdoc_stamp)::text = (w_apinvdet."timestamp")::text)
2. 1,259.094 18,203.416 ↑ 2.5 544,249 1

Hash Left Join (cost=131,638.65..246,063.25 rows=1,343,968 width=168) (actual time=4,895.882..18,203.416 rows=544,249 loops=1)

  • Hash Cond: ((w_arinvdet.inven)::text = (w_inventry.id)::text)
3. 2,408.917 16,854.728 ↑ 2.5 544,249 1

Hash Right Join (cost=128,712.22..224,676.07 rows=1,343,968 width=155) (actual time=4,806.113..16,854.728 rows=544,249 loops=1)

  • Hash Cond: ((w_arinvdet.doc_aid)::text = (w_arinv.autoid)::text)
4. 4,165.242 14,119.276 ↓ 1.1 1,444,345 1

Hash Right Join (cost=117,840.28..196,836.65 rows=1,343,968 width=124) (actual time=4,479.060..14,119.276 rows=1,444,345 loops=1)

  • Hash Cond: ((w_inlink.cdoc_stamp)::text = (w_arinvdet."timestamp")::text)
5. 5,478.355 5,478.355 ↑ 1.0 1,154,921 1

Seq Scan on inlink w_inlink (cost=0.00..28,580.21 rows=1,154,921 width=20) (actual time=0.020..5,478.355 rows=1,154,921 loops=1)

6. 2,041.620 4,475.679 ↑ 1.0 1,343,968 1

Hash (cost=80,040.68..80,040.68 rows=1,343,968 width=104) (actual time=4,475.679..4,475.679 rows=1,343,968 loops=1)

  • Buckets: 524288 Batches: 4 Memory Usage: 49282kB
7. 2,434.059 2,434.059 ↑ 1.0 1,343,968 1

Seq Scan on arinvdet w_arinvdet (cost=0.00..80,040.68 rows=1,343,968 width=104) (actual time=0.106..2,434.059 rows=1,343,968 loops=1)

8. 128.059 326.535 ↑ 1.0 100,886 1

Hash (cost=9,610.86..9,610.86 rows=100,886 width=48) (actual time=326.535..326.535 rows=100,886 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 9030kB
9. 198.476 198.476 ↑ 1.0 100,886 1

Seq Scan on arinv w_arinv (cost=0.00..9,610.86 rows=100,886 width=48) (actual time=0.021..198.476 rows=100,886 loops=1)

10. 31.839 89.594 ↑ 1.0 27,575 1

Hash (cost=2,581.75..2,581.75 rows=27,575 width=13) (actual time=89.594..89.594 rows=27,575 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1462kB
11. 57.755 57.755 ↑ 1.0 27,575 1

Seq Scan on inventry w_inventry (cost=0.00..2,581.75 rows=27,575 width=13) (actual time=0.022..57.755 rows=27,575 loops=1)

12. 284.674 568.225 ↑ 1.0 216,062 1

Hash (cost=9,370.62..9,370.62 rows=216,062 width=42) (actual time=568.225..568.225 rows=216,062 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 18183kB
13. 283.551 283.551 ↑ 1.0 216,062 1

Seq Scan on apinvdet w_apinvdet (cost=0.00..9,370.62 rows=216,062 width=42) (actual time=0.031..283.551 rows=216,062 loops=1)