explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xy6T

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 9,484.529 ↓ 3.0 3 1

Unique (cost=863,254.69..863,254.70 rows=1 width=48) (actual time=9,484.525..9,484.529 rows=3 loops=1)

2. 0.032 9,484.525 ↓ 13.0 13 1

Sort (cost=863,254.69..863,254.69 rows=1 width=48) (actual time=9,484.525..9,484.525 rows=13 loops=1)

  • Sort Key: a.seq, a.cusdecid, a.car, a.jns_dok
  • Sort Method: quicksort Memory: 26kB
3. 1,457.798 9,484.493 ↓ 13.0 13 1

Nested Loop (cost=742,467.32..863,254.68 rows=1 width=48) (actual time=9,484.338..9,484.493 rows=13 loops=1)

4. 10.569 5,559.759 ↓ 2,466,936.0 2,466,936 1

Gather (cost=742,466.76..863,251.99 rows=1 width=48) (actual time=4,500.026..5,559.759 rows=2,466,936 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 584.270 5,549.190 ↓ 822,312.0 822,312 3 / 3

Hash Join (cost=741,466.76..862,251.89 rows=1 width=48) (actual time=4,497.895..5,549.190 rows=822,312 loops=3)

  • Hash Cond: (((a.car)::text = (c.car)::text) AND (a.cusdecid = c.cusdecid))
6. 493.299 493.299 ↑ 1.1 948,373 3 / 3

Parallel Seq Scan on tblctl_postborder a (cost=0.00..104,184.27 rows=1,088,581 width=48) (actual time=0.019..493.299 rows=948,373 loops=3)

  • Filter: (((status)::text = '2'::text) AND ((fl_kirim)::text = 'N'::text))
  • Rows Removed by Filter: 481,332
7. 1,444.152 4,471.621 ↓ 1.1 5,408,970 3 / 3

Hash (cost=668,170.18..668,170.18 rows=4,886,439 width=35) (actual time=4,471.621..4,471.621 rows=5,408,970 loops=3)

  • Buckets: 8,388,608 Batches: 1 Memory Usage: 445,855kB
8. 3,027.469 3,027.469 ↓ 1.1 5,408,970 3 / 3

Seq Scan on tblpibhdr c (cost=0.00..668,170.18 rows=4,886,439 width=35) (actual time=0.049..3,027.469 rows=5,408,970 loops=3)

  • Filter: ((pibtg IS NOT NULL) AND ((COALESCE(pibno, ''::character varying))::text <> ''::text))
  • Rows Removed by Filter: 66,860
9. 2,466.936 2,466.936 ↓ 0.0 0 2,466,936

Index Only Scan using seq_kdoga_tblrealisasi_postborder_idx on tblrealisasi_postborder b (cost=0.56..2.17 rows=52 width=8) (actual time=0.001..0.001 rows=0 loops=2,466,936)

  • Index Cond: ((seq = a.seq) AND (kd_oga = '05'::text))
  • Heap Fetches: 13
Planning time : 3.262 ms
Execution time : 10,055.652 ms