explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aMB9

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

Redistribute Motion 16:16 (slice6; segments: 16) (cost=78,319,153.49..78,319,153.52 rows=1 width=49) (actual rows= loops=)

  • Hash Key: (nextval('ibs731.sgmt_adic_kli_id_seq'::regclass))
  • Rows out: Avg 969213.9 rows x 16 workers at destination. Max 969215 rows (seg3) with 778195 ms to first row, 953810 ms to end.
  • (slice0) Executor memory: 410K bytes avg x 16 workers, 410K bytes max (seg0).
  • (slice1) Executor memory: 414K bytes avg x 16 workers, 414K bytes max (seg0).
  • (slice2) * Executor memory: 491645K bytes avg x 16 workers, 553701K bytes max (seg5). Work_mem: 262518K bytes max, 1677770K bytes wanted.
  • (slice3) * Executor memory: 581634K bytes avg x 16 workers, 581660K bytes max (seg6). Work_mem: 581059K bytes max, 214914K bytes wanted.
  • (slice4) Executor memory: 581556K bytes avg x 16 workers, 581556K bytes max (seg0). Work_mem: 581059K bytes max.
  • (slice5) * Executor memory: 580122K bytes avg x 16 workers, 592453K bytes max (seg2). Work_mem: 225860K bytes max, 504392K bytes wanted.
  • (slice6) * Executor memory: 552109K bytes avg x 16 workers, 552129K bytes max (seg1). Work_mem: 551628K bytes max, 428607K bytes wanted.Statement statistics:
  • Memory used: 1048576K bytes
  • Memory wanted: 23492466K bytesOptimizer status: legacy query optimizer
2. 0.000 0.000 ↓ 0.0

Subquery Scan act (cost=78,319,153.49..78,319,153.52 rows=1 width=49) (actual rows= loops=)

  • Filter: act.active
  • Rows out: Avg 969213.9 rows x 16 workers. Max 969970 rows (seg1) with 779005 ms to first row, 946016 ms to end.
3. 0.000 0.000 ↓ 0.0

Unique (cost=78,319,153.49..78,319,153.51 rows=0 width=96) (actual rows= loops=)

  • Group By: "outer".date, "outer".partner_id, coplan.adic, coplan.kli, coplan.kli_type_id, (CASE WHEN (ntile_final(coplan.ntile, (count(*))) + ntile_final(coplan.ntile, (count(*))) + ntile_final(coplan.ntile, (count(*)))) > CASE WHEN coplan.kli_type_id = 3 THEN 2 WHEN ntile_final(coplan.ntile, (count(*))) = 3 THEN 5 ELSE 4 END THEN true ELSE false END)
  • Rows out: Avg 1341265.3 rows x 16 workers. Max 1342799 rows (seg10) with 778474 ms to first row, 786016 ms to end.
4. 0.000 0.000 ↓ 0.0

Sort (cost=78,319,153.49..78,319,153.50 rows=1 width=96) (actual rows= loops=)

  • Sort Key (Distinct): coplan.adic, coplan.kli, coplan.kli_type_id, (CASE WHEN (ntile_final(coplan.ntile, (count(*))) + ntile_final(coplan.ntile, (count(*))) + ntile_final(coplan.ntile, (count(*)))) > CASE WHEN coplan.kli_type_id = 3 THEN 2 WHEN ntile_final(coplan.ntile, (count(*))) = 3 THEN 5 ELSE 4 END THEN true ELSE false END)
  • Sort Method: external merge Max Disk: 115776KB Avg Disk: 115616KB (16 segments)
  • Rows out: Avg 1341265.3 rows x 16 workers. Max 1342799 rows (seg10) with 778474 ms to first row, 784514 ms to end.
  • Executor memory: 551628K bytes avg, 551628K bytes max (seg0).
  • Work_mem used: 551628K bytes avg, 551628K bytes max (seg0). Workfile: (16 spilling)
  • Work_mem wanted: 428118K bytes avg, 428607K bytes max (seg10) to lessen workfile I/O affecting 16 workers.
5. 0.000 0.000 ↓ 0.0

Redistribute Motion 16:16 (slice5; segments: 16) (cost=78,319,153.19..78,319,153.48 rows=1 width=96) (actual rows= loops=)

  • Hash Key: "outer".date, "outer".partner_id, coplan.adic, coplan.kli, coplan.kli_type_id, (CASE WHEN (ntile_final(coplan.ntile, (count(*))) + ntile_final(coplan.ntile, (count(*))) + ntile_final(coplan.ntile, (count(*)))) > CASE WHEN coplan.kli_type_id = 3 THEN 2 WHEN ntile_final(coplan.ntile, (count(*))) = 3 THEN 5 ELSE 4 END THEN true ELSE false END)
  • Rows out: Avg 1341265.3 rows x 16 workers at destination. Max 1342799 rows (seg10) with 747419 ms to first row, 768233 ms to end.
6. 0.000 0.000 ↓ 0.0

Merge Join (cost=78,319,153.19..78,319,153.46 rows=1 width=96) (actual rows= loops=)

  • Merge Cond: NOT share0_ref1.kli IS DISTINCT FROM coplan.kli
  • Rows out: Avg 1341265.3 rows x 16 workers. Max 1679452 rows (seg2) with 757847 ms to first row, 764680 ms to end.
7. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=39,159,576.47..39,159,576.68 rows=1 width=12) (actual rows= loops=)

  • Group By: share0_ref1.kli
  • Rows out: Avg 844.1 rows x 16 workers. Max 891 rows (seg0) with 730205 ms to first row, 731415 ms to end.
8. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 5:0) (cost=39,159,576.47..39,159,576.67 rows=1 width=84) (actual rows= loops=)

  • Rows out: Avg 1341265.3 rows x 16 workers. Max 1679452 rows (seg2) with 732159 ms to first row, 732743 ms to end.
9. 0.000 0.000 ↓ 0.0

Sort (cost=39,159,576.46..39,159,576.47 rows=1 width=84) (actual rows= loops=)

  • Sort Key: wtl.term_code, ('2020-03-16'::date - max((max(std.process_date))))
  • Sort Method: quicksort Max Memory: 219774KB Avg Memory: 197739KB (7 segments)
  • Sort Method: external sort Max Disk: 137952KB Avg Disk: 121329KB (9 segments)
  • Rows out: 0 rows (seg0) with 732378 ms to end.
  • Executor memory: 213557K bytes avg, 225860K bytes max (seg2).
  • Work_mem used: 213557K bytes avg, 225860K bytes max (seg2). Workfile: (9 spilling)
  • Work_mem wanted: 242555K bytes avg, 275809K bytes max (seg2) to lessen workfile I/O affecting 9 workers.
10. 0.000 0.000 ↓ 0.0

Redistribute Motion 16:16 (slice4; segments: 16) (cost=39,159,576.40..39,159,576.45 rows=1 width=84) (actual rows= loops=)

  • Hash Key: wtl.term_code
  • Rows out: Avg 1341265.3 rows x 16 workers at destination. Max 1679452 rows (seg2) with 715259 ms to first row, 724879 ms to end.
11. 0.000 0.000 ↓ 0.0

Unique (cost=39,159,576.40..39,159,576.42 rows=1 width=84) (actual rows= loops=)

  • Group By: std.adic, wtl.term_code, (min((min(CASE WHEN wtl.competitive THEN 3 ELSE 4 END)))), ('2020-03-16'::date - max((max(std.process_date)))), (count((count(9)))), (sum((sum(abs(std.trans_amount)))))
  • Rows out: Avg 1341265.3 rows x 16 workers. Max 1342819 rows (seg3) with 716334 ms to first row, 719262 ms to end.
12. 0.000 0.000 ↓ 0.0

Sort (cost=39,159,576.40..39,159,576.41 rows=1 width=84) (actual rows= loops=)

  • Sort Key (Distinct): std.adic, wtl.term_code, (min((min(CASE WHEN wtl.competitive THEN 3 ELSE 4 END)))), ('2020-03-16'::date - max((max(std.process_date)))), (count((count(9)))), (sum((sum(abs(std.trans_amount)))))
  • Sort Method: quicksort Max Memory: 581059KB Avg Memory: 581059KB (16 segments)
  • Rows out: Avg 1341265.3 rows x 16 workers. Max 1342819 rows (seg3) with 716334 ms to first row, 717115 ms to end.
  • Executor memory: 581059K bytes avg, 581059K bytes max (seg0).
  • Work_mem used: 581059K bytes avg, 581059K bytes max (seg0). Workfile: (0 spilling)
13. 0.000 0.000 ↓ 0.0

Redistribute Motion 16:16 (slice3; segments: 16) (cost=39,116,806.37..39,159,576.39 rows=1 width=84) (actual rows= loops=)

  • Hash Key: std.adic, wtl.term_code, (min((min(CASE WHEN wtl.competitive THEN 3 ELSE 4 END)))), ('2020-03-16'::date - max((max(std.process_date)))), (count((count(9)))), (sum((sum(abs(std.trans_amount)))))
  • Rows out: Avg 1341265.3 rows x 16 workers at destination. Max 1342819 rows (seg3) with 688792 ms to first row, 706857 ms to end.
14. 0.000 0.000 ↓ 0.0

Unique (cost=39,116,806.37..39,159,576.37 rows=1 width=84) (actual rows= loops=)

  • Group By: std.adic, wtl.term_code, (min((min(CASE WHEN wtl.competitive THEN 3 ELSE 4 END)))), ('2020-03-16'::date - max((max(std.process_date)))), (count((count(9)))), (sum((sum(abs(std.trans_amount)))))
  • Rows out: Avg 1341265.3 rows x 16 workers. Max 1343073 rows (seg5) with 691071 ms to first row, 694471 ms to end.
15. 0.000 0.000 ↓ 0.0

Sort (cost=39,116,806.37..39,122,916.37 rows=152,750 width=84) (actual rows= loops=)

  • Sort Key (Distinct): std.adic, wtl.term_code, (min((min(CASE WHEN wtl.competitive THEN 3 ELSE 4 END)))), ('2020-03-16'::date - max((max(std.process_date)))), (count((count(9)))), (sum((sum(abs(std.trans_amount)))))
  • Sort Method: quicksort Max Memory: 581059KB Avg Memory: 581059KB (16 segments)
  • Rows out: Avg 1341265.3 rows x 16 workers. Max 1343073 rows (seg5) with 691071 ms to first row, 691825 ms to end.
  • Executor memory: 581059K bytes avg, 581059K bytes max (seg0).
  • Work_mem used: 581059K bytes avg, 581059K bytes max (seg0). Workfile: (0 spilling)
16. 0.000 0.000 ↓ 0.0

HashAggregate (cost=38,782,509.27..38,857,488.04 rows=152,750 width=84) (actual rows= loops=)

  • Group By: std.adic, wtl.term_code
  • Rows out: Avg 1341265.3 rows x 16 workers. Max 1343073 rows (seg5) with 682181 ms to first row, 683806 ms to end.
  • Executor memory: 175764K bytes avg, 175764K bytes max (seg0).
  • Work_mem used: 174946K bytes avg, 174947K bytes max (seg5). Workfile: (16 spilling)
  • Work_mem wanted: 214602K bytes avg, 214914K bytes max (seg13) to lessen workfile I/O affecting 16 workers.
  • (seg13) 1342729 groups total in 32 batches; 1 overflows; 1746967 spill groups.
  • (seg13) Hash chain length 3.3 avg, 16 max, using 741737 of 786432 buckets; total 1 expansions.
17. 0.000 0.000 ↓ 0.0

Redistribute Motion 16:16 (slice2; segments: 16) (cost=38,415,941.26..38,701,420.50 rows=152,750 width=84) (actual rows= loops=)

  • Hash Key: std.adic, wtl.term_code
  • Rows out: Avg 5461776.9 rows x 16 workers at destination. Max 5474144 rows (seg5) with 528090 ms to first row, 672937 ms to end.
18. 0.000 0.000 ↓ 0.0

HashAggregate (cost=38,415,941.26..38,652,540.50 rows=152,750 width=84) (actual rows= loops=)

  • Group By: std.adic, wtl.term_code
  • Rows out: Avg 5461776.9 rows x 16 workers. Max 7845294 rows (seg15) with 528013 ms to first row, 673280 ms to end.
  • Executor memory: 175361K bytes avg, 175361K bytes max (seg0).
  • (seg5) Hash chain length 4.0 avg, 18 max, using 1785248 of 1835008 buckets; total 1 expansions.
  • (seg15) Hash chain length 4.0 avg, 17 max, using 1942299 of 2097152 buckets; total 1 expansions.
19. 0.000 0.000 ↓ 0.0

Hash Join (cost=3,664,780.08..38,106,867.39 rows=1,287,808 width=73) (actual rows= loops=)

  • Hash Cond: wtl.trans_desc = std.trans_desc
  • Join Filter: std.process_date >= CASE WHEN wtl.competitive THEN '2019-09-16'::date ELSE '2019-03-16'::date END
  • Rows out: Avg 11315275.2 rows x 16 workers. Max 16141167 rows (seg15) with 325396 ms to first row, 646150 ms to end.
  • Executor memory: 200497K bytes avg, 262518K bytes max (seg15).
  • Work_mem used: 200497K bytes avg, 262518K bytes max (seg15). Workfile: (16 spilling)
  • Work_mem wanted: 1151693K bytes avg, 1677770K bytes max (seg15) to lessen workfile I/O affecting 16 workers.
  • (seg5) Initial batch 0:
  • (seg5) Wrote 1255328K bytes to inner workfile.
  • (seg5) Wrote 4533248K bytes to outer workfile.
  • (seg5) Initial batch 1:
  • (seg5) Read 425206K bytes from inner workfile.
  • (seg5) Wrote 282512K bytes to inner workfile.
  • (seg5) Read 647570K bytes from outer workfile.
  • (seg5) Overflow batches 2..7:
  • (seg5) Read 1216948K bytes from inner workfile: 202825K avg x 6 nonempty batches, 351027K max.
  • (seg5) Wrote 737200K bytes to inner workfile: 122867K avg x 6 overflowing batches, 284592K max.
  • (seg5) Read 3884623K bytes from outer workfile: 647438K avg x 6 nonempty batches, 647739K max.
  • (seg5) Wrote 1943024K bytes to outer workfile: 323838K avg x 6 overflowing batches, 324144K max.
  • (seg5) Secondary Overflow batches 8..16383:
  • (seg5) Read 2356299K bytes from inner workfile: 35702K avg x 66 nonempty batches, 284523K max.
  • (seg5) Wrote 1723840K bytes to inner workfile: 39179K avg x 44 overflowing batches, 246384K max.
  • (seg5) Read 3035940K bytes from outer workfile: 46000K avg x 66 nonempty batches, 324079K max.
  • (seg5) Wrote 1093120K bytes to outer workfile: 26027K avg x 42 overflowing batches, 162080K max.
  • (seg5) Hash chain length 19.3 avg, 3133864 max, using 840893 of 38797312 buckets. Skipped 16310 empty batches.
  • (seg15) Initial batch 0:
  • (seg15) Wrote 1343520K bytes to inner workfile.
  • (seg15) Wrote 4533248K bytes to outer workfile.
  • (seg15) Initial batch 1:
  • (seg15) Read 440321K bytes from inner workfile.
  • (seg15) Wrote 287728K bytes to inner workfile.
  • (seg15) Read 647570K bytes from outer workfile.
  • (seg15) Overflow batches 2..7:
  • (seg15) Read 1294325K bytes from inner workfile: 215721K avg x 6 nonempty batches, 375267K max.
  • (seg15) Wrote 781088K bytes to inner workfile: 130182K avg x 6 overflowing batches, 304720K max.
  • (seg15) Read 3884623K bytes from outer workfile: 647438K avg x 6 nonempty batches, 647739K max.
  • (seg15) Wrote 1943024K bytes to outer workfile: 323838K avg x 6 overflowing batches, 324144K max.
  • (seg15) Secondary Overflow batches 8..16383:
  • (seg15) Read 2524380K bytes from inner workfile: 38249K avg x 66 nonempty batches, 304659K max.
  • (seg15) Wrote 1847120K bytes to inner workfile: 41980K avg x 44 overflowing batches, 264096K max.
  • (seg15) Read 3035940K bytes from outer workfile: 46000K avg x 66 nonempty batches, 324079K max.
  • (seg15) Wrote 1093120K bytes to outer workfile: 26027K avg x 42 overflowing batches, 162080K max.
  • (seg15) Hash chain length 20.0 avg, 3358509 max, using 869758 of 38797312 buckets. Skipped 16310 empty batches.
20. 0.000 0.000 ↓ 0.0

Broadcast Motion 16:16 (slice1; segments: 16) (cost=0.00..18,641,458.56 rows=102,277,192 width=38) (actual rows= loops=)

  • Rows out: Avg 102277191.0 rows x 16 workers at destination. Max 102277191 rows (seg0) with 0.084 ms to first row, 119107 ms to end.
21. 0.000 0.000 ↓ 0.0

Seq Scan on wand_trans_lookup wtl (cost=0.00..1,254,335.92 rows=6,392,325 width=38) (actual rows= loops=)

  • Rows out: Avg 6392324.4 rows x 16 workers. Max 6392325 rows (seg0) with 0.107 ms to first row, 5463 ms to end.
22. 0.000 0.000 ↓ 0.0

Hash (cost=2,967,650.03..2,967,650.03 rows=2,655,731 width=100) (actual rows= loops=)

  • Rows in: Avg 1122560.0 rows x 16 workers. Max 1461426 rows (seg12) with 268215 ms to end, start offset by 5287 ms.
23. 0.000 0.000 ↓ 0.0

Subquery Scan std (cost=0.00..2,967,650.03 rows=2,655,731 width=100) (actual rows= loops=)

  • Rows out: Avg 11930059.1 rows x 16 workers. Max 17366794 rows (seg15) with 600 ms to first row, 304290 ms to end.
24. 0.000 0.000 ↓ 0.0

Append (cost=0.00..2,542,733.18 rows=2,655,731 width=100) (actual rows= loops=)

  • Rows out: Avg 11930059.1 rows x 16 workers. Max 17366794 rows (seg15) with 600 ms to first row, 290690 ms to end.
25. 0.000 0.000 ↓ 0.0

Subquery Scan dep (cost=0.00..2,042,825.23 rows=2,581,216 width=100) (actual rows= loops=)

  • Rows out: Avg 11646236.3 rows x 16 workers. Max 17049393 rows (seg15) with 600 ms to first row, 263840 ms to end.
26. 0.000 0.000 ↓ 0.0

Append (cost=0.00..1,629,830.77 rows=2,581,216 width=357) (actual rows= loops=)

  • Rows out: Avg 11646236.3 rows x 16 workers. Max 17049393 rows (seg15) with 600 ms to first row, 250436 ms to end.
27. 0.000 0.000 ↓ 0.0

Append (cost=0.00..1,195,836.32 rows=2,581,203 width=356) (actual rows= loops=)

  • Rows out: Avg 3513741.1 rows x 16 workers. Max 3716988 rows (seg2) with 578 ms to first row, 13752 ms to end.
28. 0.000 0.000 ↓ 0.0

Append-only Scan on std_deposit_transaction_1_prt_r913515052 std_deposit_transaction (cost=0.00..359,559.22 rows=776,045 width=356) (actual rows= loops=)

  • Filter: (deptrans_customer_relationship_type = ANY ('{1,2}'::integer[])) AND process_date >= '2019-03-16'::date AND process_date <= '2020-03-16'::date AND process_date <= '2020-03-16'::date
  • Rows out: Avg 1031172.6 rows x 16 workers. Max 1086066 rows (seg2) with 578 ms to first row, 3096 ms to end.
29. 0.000 0.000 ↓ 0.0

Append-only Scan on std_deposit_transaction_1_prt_r1683544888 std_deposit_transaction (cost=0.00..348,341.74 rows=753,153 width=354) (actual rows= loops=)

  • Filter: (deptrans_customer_relationship_type = ANY ('{1,2}'::integer[])) AND process_date >= '2019-03-16'::date AND process_date <= '2020-03-16'::date AND process_date <= '2020-03-16'::date
  • Rows out: Avg 1000658.6 rows x 16 workers. Max 1058243 rows (seg2) with 192 ms to first row, 2714 ms to end.
30. 0.000 0.000 ↓ 0.0

Append-only Scan on std_deposit_transaction_1_prt_r1104069569 std_deposit_transaction (cost=0.00..315,947.52 rows=680,665 width=356) (actual rows= loops=)

  • Filter: (deptrans_customer_relationship_type = ANY ('{1,2}'::integer[])) AND process_date >= '2019-03-16'::date AND process_date <= '2020-03-16'::date AND process_date <= '2020-03-16'::date
  • Rows out: Avg 904836.0 rows x 16 workers. Max 957212 rows (seg2) with 157 ms to first row, 2456 ms to end.
31. 0.000 0.000 ↓ 0.0

Append-only Scan on std_deposit_transaction_1_prt_r915384697 std_deposit_transaction (cost=0.00..171,747.84 rows=371,343 width=357) (actual rows= loops=)

  • Filter: (deptrans_customer_relationship_type = ANY ('{1,2}'::integer[])) AND process_date >= '2019-03-16'::date AND process_date <= '2020-03-16'::date AND process_date <= '2020-03-16'::date
  • Rows out: Avg 577074.0 rows x 16 workers. Max 615467 rows (seg2) with 82 ms to first row, 1844 ms to end.
32. 0.000 0.000 ↓ 0.0

Append-only Scan on std_deposit_transaction_1_prt_r1072466215 std_deposit_transaction (cost=0.00..240.00 rows=1 width=432) (actual rows= loops=)

  • Filter: (deptrans_customer_relationship_type = ANY ('{1,2}'::integer[])) AND process_date >= '2019-03-16'::date AND process_date <= '2020-03-16'::date AND process_date <= '2020-03-16'::date
  • Rows out: 0 rows (seg0) with 215 ms to end.
33. 0.000 0.000 ↓ 0.0

External Scan on s3_std_deposit_transaction (cost=0.00..21,000.00 rows=13 width=432) (actual rows= loops=)

  • Filter: (deptrans_customer_relationship_type = ANY ('{1,2}'::integer[])) AND process_date >= '2019-03-16'::date AND process_date <= '2020-03-16'::date AND process_date <= '2020-03-16'::date
  • Rows out: Avg 8132495.2 rows x 16 workers. Max 13422776 rows (seg15) with 6905 ms to first row, 224972 ms to end.
34. 0.000 0.000 ↓ 0.0

Subquery Scan crd (cost=0.00..74,991.11 rows=74,515 width=100) (actual rows= loops=)

  • Rows out: Avg 283822.8 rows x 16 workers. Max 408046 rows (seg14) with 864 ms to first row, 16955 ms to end.
35. 0.000 0.000 ↓ 0.0

Append (cost=0.00..63,068.73 rows=74,515 width=424) (actual rows= loops=)

  • Rows out: Avg 283822.8 rows x 16 workers. Max 408046 rows (seg14) with 864 ms to first row, 16648 ms to end.
36. 0.000 0.000 ↓ 0.0

Append (cost=0.00..30,146.34 rows=74,503 width=423) (actual rows= loops=)

  • Rows out: Avg 87805.2 rows x 16 workers. Max 107996 rows (seg0) with 423 ms to first row, 2781 ms to end.
37. 0.000 0.000 ↓ 0.0

Append-only Scan on std_card_transaction_1_prt_r1117141701 std_card_transaction (cost=0.00..8,904.70 rows=22,134 width=423) (actual rows= loops=)

  • Filter: (cardtrans_customer_relationship_type = ANY ('{1,2}'::integer[])) AND process_date >= '2019-03-16'::date AND process_date <= '2020-03-16'::date AND process_date <= '2020-03-16'::date
  • Rows out: Avg 25274.1 rows x 16 workers. Max 30783 rows (seg0) with 423 ms to first row, 606 ms to end.
38. 0.000 0.000 ↓ 0.0

Append-only Scan on std_card_transaction_1_prt_r581804541 std_card_transaction (cost=0.00..8,703.46 rows=21,690 width=423) (actual rows= loops=)

  • Filter: (cardtrans_customer_relationship_type = ANY ('{1,2}'::integer[])) AND process_date >= '2019-03-16'::date AND process_date <= '2020-03-16'::date AND process_date <= '2020-03-16'::date
  • Rows out: Avg 24745.2 rows x 16 workers. Max 30844 rows (seg0) with 449 ms to first row, 515 ms to end.
39. 0.000 0.000 ↓ 0.0

Append-only Scan on std_card_transaction_1_prt_r785922870 std_card_transaction (cost=0.00..8,294.36 rows=20,650 width=421) (actual rows= loops=)

  • Filter: (cardtrans_customer_relationship_type = ANY ('{1,2}'::integer[])) AND process_date >= '2019-03-16'::date AND process_date <= '2020-03-16'::date AND process_date <= '2020-03-16'::date
  • Rows out: Avg 23585.5 rows x 16 workers. Max 29293 rows (seg0) with 607 ms to first row, 651 ms to end.
40. 0.000 0.000 ↓ 0.0

Append-only Scan on std_card_transaction_1_prt_r47912725 std_card_transaction (cost=0.00..4,045.82 rows=10,030 width=423) (actual rows= loops=)

  • Filter: (cardtrans_customer_relationship_type = ANY ('{1,2}'::integer[])) AND process_date >= '2019-03-16'::date AND process_date <= '2020-03-16'::date AND process_date <= '2020-03-16'::date
  • Rows out: Avg 14200.5 rows x 16 workers. Max 17076 rows (seg0) with 451 ms to first row, 507 ms to end.
41. 0.000 0.000 ↓ 0.0

Append-only Scan on std_card_transaction_1_prt_r293940350 std_card_transaction (cost=0.00..198.00 rows=1 width=628) (actual rows= loops=)

  • Filter: (cardtrans_customer_relationship_type = ANY ('{1,2}'::integer[])) AND process_date >= '2019-03-16'::date AND process_date <= '2020-03-16'::date AND process_date <= '2020-03-16'::date
  • Rows out: 0 rows (seg0) with 598 ms to end.
42. 0.000 0.000 ↓ 0.0

External Scan on s3_std_card_transaction (cost=0.00..21,000.00 rows=13 width=628) (actual rows= loops=)

  • Filter: (cardtrans_customer_relationship_type = ANY ('{1,2}'::integer[])) AND process_date >= '2019-03-16'::date AND process_date <= '2020-03-16'::date AND process_date <= '2020-03-16'::date
  • Rows out: Avg 196017.5 rows x 16 workers. Max 321398 rows (seg14) with 1148 ms to first row, 12423 ms to end.
43. 0.000 0.000 ↓ 0.0

Subquery Scan coplan (cost=39,159,576.72..39,159,576.74 rows=1 width=84) (actual rows= loops=)

  • Rows out: Avg 1341265.3 rows x 16 workers. Max 1679452 rows (seg2) with 25687 ms to first row, 29170 ms to end.
44. 0.000 0.000 ↓ 0.0

Window (cost=39,159,576.72..39,159,576.73 rows=1 width=84) (actual rows= loops=)

  • Partition By: coplan.kli
  • Order By: coplan.monetary
  • Rows out: Avg 1341265.3 rows x 16 workers. Max 1679452 rows (seg2) with 25687 ms to first row, 28342 ms to end.
45. 0.000 0.000 ↓ 0.0

Sort (cost=39,159,576.72..39,159,576.73 rows=1 width=84) (actual rows= loops=)

  • Sort Key: coplan.kli, coplan.monetary
  • Sort Method: external sort Max Disk: 328224KB Avg Disk: 262132KB (16 segments)
  • Rows out: Avg 1341265.3 rows x 16 workers. Max 1679452 rows (seg2) with 25687 ms to first row, 26419 ms to end.
  • Executor memory: 182761K bytes avg, 182761K bytes max (seg0).
  • Work_mem used: 182761K bytes avg, 182761K bytes max (seg0). Workfile: (16 spilling)
  • Work_mem wanted: 402824K bytes avg, 504392K bytes max (seg2) to lessen workfile I/O affecting 16 workers.
46. 0.000 0.000 ↓ 0.0

Subquery Scan coplan (cost=39,159,576.69..39,159,576.71 rows=1 width=84) (actual rows= loops=)

  • Rows out: Avg 1341265.3 rows x 16 workers. Max 1679452 rows (seg2) with 11170 ms to first row, 15830 ms to end.
47. 0.000 0.000 ↓ 0.0

Window (cost=39,159,576.69..39,159,576.70 rows=1 width=84) (actual rows= loops=)

  • Partition By: coplan.kli
  • Order By: coplan.frequency
  • Rows out: Avg 1341265.3 rows x 16 workers. Max 1679452 rows (seg2) with 11170 ms to first row, 14585 ms to end.
48. 0.000 0.000 ↓ 0.0

Sort (cost=39,159,576.69..39,159,576.70 rows=1 width=84) (actual rows= loops=)

  • Sort Key: coplan.kli, coplan.frequency
  • Sort Method: external sort Max Disk: 262592KB Avg Disk: 209706KB (16 segments)
  • Rows out: Avg 1341265.3 rows x 16 workers. Max 1679452 rows (seg2) with 11170 ms to first row, 12189 ms to end.
  • Executor memory: 183106K bytes avg, 183106K bytes max (seg0).
  • Work_mem used: 183106K bytes avg, 183106K bytes max (seg0). Workfile: (16 spilling)
  • Work_mem wanted: 393802K bytes avg, 493095K bytes max (seg2) to lessen workfile I/O affecting 16 workers.
49. 0.000 0.000 ↓ 0.0

Subquery Scan coplan (cost=39,159,576.47..39,159,576.68 rows=1 width=84) (actual rows= loops=)

  • Rows out: Avg 1341265.3 rows x 16 workers. Max 1679452 rows (seg2) with 0.088 ms to first row, 5521 ms to end.
50. 0.000 0.000 ↓ 0.0

Window (cost=39,159,576.47..39,159,576.67 rows=1 width=84) (actual rows= loops=)

  • Partition By: share0_ref2.kli
  • Order By: share0_ref2.recency
  • Rows out: Avg 1341265.3 rows x 16 workers. Max 1679452 rows (seg2) with 0.075 ms to first row, 3845 ms to end.
51. 0.000 0.000 ↓ 0.0

Shared Scan (share slice:id 5:0) (cost=39,159,576.47..39,159,576.67 rows=1 width=84) (actual rows= loops=)

  • Rows out: Avg 1341265.3 rows x 16 workers. Max 1679452 rows (seg2) with 0.032 ms to first row, 1027 ms to end.Slice statistics:
Total runtime : 964,615.657 ms