explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vmZR

Settings
# exclusive inclusive rows x rows loops node
1. 126.388 7,940.326 ↓ 0.0 0 1

Gather (cost=1,008.60..182,743.65 rows=1 width=64) (actual time=7,940.326..7,940.326 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.086 7,813.938 ↓ 0.0 0 3 / 3

Nested Loop Left Join (cost=8.60..181,743.55 rows=1 width=64) (actual time=7,813.938..7,813.938 rows=0 loops=3)

  • Filter: (d.id IS NULL)
  • Rows Removed by Filter: 37
3. 107.566 1,418.766 ↓ 10.0 30 3 / 3

Nested Loop (cost=8.04..104,004.01 rows=3 width=32) (actual time=1,339.025..1,418.766 rows=30 loops=3)

4. 59.816 237.385 ↓ 22.3 268,454 3 / 3

Hash Join (cost=7.61..65,363.96 rows=12,058 width=21) (actual time=0.174..237.385 rows=268,454 loops=3)

  • Hash Cond: ((a.kd_kantor)::text = (c.kdkpbc)::text)
5. 177.486 177.486 ↑ 1.1 268,455 3 / 3

Parallel Seq Scan on tbllartas_hdr a (cost=0.00..61,774.07 rows=287,983 width=14) (actual time=0.017..177.486 rows=268,455 loops=3)

  • Filter: ((kd_status)::text = '5'::text)
  • Rows Removed by Filter: 436,707
6. 0.018 0.083 ↓ 48.0 96 3 / 3

Hash (cost=7.59..7.59 rows=2 width=20) (actual time=0.083..0.083 rows=96 loops=3)

  • Buckets: 1,024 Batches: 1 Memory Usage: 13kB
7. 0.065 0.065 ↓ 48.0 96 3 / 3

Seq Scan on tblpartner c (cost=0.00..7.59 rows=2 width=20) (actual time=0.040..0.065 rows=96 loops=3)

  • Filter: ((fl_edi)::text = '3'::text)
  • Rows Removed by Filter: 111
8. 1,073.815 1,073.815 ↓ 0.0 0 805,361 / 3

Index Scan using idx_cus_pasokneg on tblpibhdr b (cost=0.43..3.20 rows=1 width=27) (actual time=0.004..0.004 rows=0 loops=805,361)

  • Index Cond: (cusdecid = a.cusdecid)
  • Filter: ((edinumber)::text = 'CEISA40'::text)
  • Rows Removed by Filter: 1
9. 6,395.086 6,395.086 ↑ 1.0 1 91 / 3

Index Scan using senderedi_postbox_idx on postbox d (cost=0.56..25,913.17 rows=1 width=19) (actual time=25.773..210.827 rows=1 loops=91)

  • Index Cond: ((b.snrf)::text = (snrf)::text)
Planning time : 3.504 ms
Execution time : 8,158.701 ms