explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jCu2 : q1

Settings
# exclusive inclusive rows x rows loops node
1. 9,966.548 89,759.624 ↓ 1.0 7,579,436 1

WindowAgg (cost=2,763,845.89..2,971,930.03 rows=7,566,696 width=176) (actual time=76,685.934..89,759.624 rows=7,579,436 loops=1)

2. 64,625.968 79,793.076 ↓ 1.0 7,579,436 1

Sort (cost=2,763,845.89..2,782,762.63 rows=7,566,696 width=126) (actual time=76,685.879..79,793.076 rows=7,579,436 loops=1)

  • SORT KEY: S."SHIPMENT_ID", W."LASERMARK
  • SORT METHOD: EXTERNAL MERGE DISK: 1122472KB
3. 4,654.662 15,167.108 ↓ 1.0 7,579,436 1

Hash Join (cost=7,094.83..425,125.26 rows=7,566,696 width=126) (actual time=45.350..15,167.108 rows=7,579,436 loops=1)

  • Hash Cond: (w."SHIPMENT_ID" = s."SHIPMENT_ID")
4. 4,266.517 10,495.554 ↑ 1.0 7,529,986 1

Hash Join (cost=2,937.97..317,033.19 rows=7,538,199 width=76) (actual time=27.830..10,495.554 rows=7,529,986 loops=1)

  • Hash Cond: (w."PARAMETER_ID" = p."PARAMETER_ID")
5. 6,201.341 6,201.341 ↑ 1.0 7,529,986 1

Append (cost=0.00..210,444.98 rows=7,538,199 width=47) (actual time=0.027..6,201.341 rows=7,529,986 loops=1)

  • -> Seq Scan on wafer_data_20190401_20190501 w (cost=0.00..137138.15 rows=4910877 width=47) (actual time=0.026..2148.081 rows=4906673 loops=
  • Filter: (("SHIPMENT_DATE" >= '2019-04-01 00:00:00'::timestamp without time zone) AND ("SHIPMENT_DATE" <= '2019-06-30 00:00:00'::timesta
  • -> Seq Scan on wafer_data_20190501_20190601 w_1 (cost=0.00..73306.83 rows=2627322 width=46) (actual time=0.010..1046.308 rows=2623313 loops
  • Filter: (("SHIPMENT_DATE" >= '2019-04-01 00:00:00'::timestamp without time zone) AND ("SHIPMENT_DATE" <= '2019-06-30 00:00:00'::timesta
6. 14.456 27.696 ↑ 1.0 33,021 1

Hash (cost=2,525.21..2,525.21 rows=33,021 width=33) (actual time=27.696..27.696 rows=33,021 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2627kB
7. 13.240 13.240 ↑ 1.0 33,021 1

Seq Scan on parameters p (cost=0.00..2,525.21 rows=33,021 width=33) (actual time=0.007..13.240 rows=33,021 loops=1)

8. 2.440 16.892 ↑ 1.0 5,576 1

Hash (cost=4,087.16..4,087.16 rows=5,576 width=58) (actual time=16.891..16.892 rows=5,576 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 573kB
9. 2.994 14.452 ↑ 1.0 5,576 1

Hash Join (cost=3,654.35..4,087.16 rows=5,576 width=58) (actual time=6.595..14.452 rows=5,576 loops=1)

  • Hash Cond: (sp."PC_ID" = pc."PC_ID")
10. 4.927 9.532 ↑ 1.0 5,576 1

Hash Join (cost=1,953.27..2,309.41 rows=5,576 width=38) (actual time=4.662..9.532 rows=5,576 loops=1)

  • Hash Cond: (sp."SHIPMENT_ID" = s."SHIPMENT_ID")
  • -> Index Only Scan using shipmentpc_idx1 on shipment_pc sp (cost=0.28..341.78 rows=5576 width=8) (actual time=0.035..1.865 rows=5576
  • Heap Fetches: 1548
11. 1.843 4.605 ↑ 1.0 5,555 1

Hash (cost=1,883.55..1,883.55 rows=5,555 width=30) (actual time=4.605..4.605 rows=5,555 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 418kB
12. 2.762 2.762 ↑ 1.0 5,555 1

Seq Scan on shipment s (cost=0.00..1,883.55 rows=5,555 width=30) (actual time=0.004..2.762 rows=5,555 loops=1)

13. 0.871 1.926 ↑ 1.0 270 1

Hash (cost=1,697.70..1,697.70 rows=270 width=28) (actual time=1.926..1.926 rows=270 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 25kB
14. 1.055 1.055 ↑ 1.0 270 1

Seq Scan on pc (cost=0.00..1,697.70 rows=270 width=28) (actual time=0.006..1.055 rows=270 loops=1)