explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mM5r

Settings
# exclusive inclusive rows x rows loops node
1. 320.362 580,258.417 ↑ 1.9 1,473,568 1

Unique (cost=6,566,477.77..6,628,305.18 rows=2,747,885 width=45) (actual time=579,739.420..580,258.417 rows=1,473,568 loops=1)

2. 1,152.565 579,938.055 ↑ 1.9 1,473,568 1

Sort (cost=6,566,477.77..6,573,347.48 rows=2,747,885 width=45) (actual time=579,739.419..579,938.055 rows=1,473,568 loops=1)

  • Sort Key: ib.invoice_id, ib.program_id, ib.db_id, ib.is_active, i.date_create, (sum(ib.quantity)), (sum(g.weight_netto)), (sum((ib.quantity * g.weight_netto)))
  • Sort Method: external merge Disk: 83544kB
3. 101.233 578,785.490 ↑ 1.9 1,473,568 1

Append (cost=1,276,991.73..6,188,060.97 rows=2,747,885 width=45) (actual time=159,816.988..578,785.490 rows=1,473,568 loops=1)

4. 857.917 160,922.376 ↓ 2.0 238,589 1

GroupAggregate (cost=1,276,991.73..1,281,223.62 rows=120,911 width=45) (actual time=159,816.987..160,922.376 rows=238,589 loops=1)

  • Group Key: ib.invoice_id, ib.program_id, ib.db_id, ib.is_active, i.date_create
5. 1,652.280 160,064.459 ↓ 17.3 2,097,152 1

Sort (cost=1,276,991.73..1,277,294.01 rows=120,911 width=37) (actual time=159,816.954..160,064.459 rows=2,097,152 loops=1)

  • Sort Key: ib.invoice_id, ib.program_id, ib.db_id, ib.is_active, i.date_create
  • Sort Method: external merge Disk: 102496kB
6. 780.353 158,412.179 ↓ 17.3 2,097,152 1

Hash Join (cost=184,450.61..1,266,784.68 rows=120,911 width=37) (actual time=26,578.107..158,412.179 rows=2,097,152 loops=1)

  • Hash Cond: (ib.goods_id = g.id)
7. 4,952.256 157,461.869 ↓ 17.3 2,097,152 1

Hash Join (cost=166,805.03..1,247,476.52 rows=120,923 width=33) (actual time=26,407.138..157,461.869 rows=2,097,152 loops=1)

  • Hash Cond: ((ib.invoice_id = i.id) AND (ib.program_id = i.program_id) AND (ib.db_id = i.db_id))
8. 141,021.879 141,021.879 ↓ 1.0 30,637,594 1

Seq Scan on invoice_body_51 ib (cost=0.00..734,963.83 rows=30,622,083 width=25) (actual time=14.896..141,021.879 rows=30,637,594 loops=1)

  • Filter: (is_active AND (invoice_id IS NOT NULL) AND (db_id IS NOT NULL) AND (program_id IS NOT NULL) AND (goods_id IS NOT NULL) AND (quantity IS NOT NULL))
9. 76.839 11,487.734 ↓ 1.6 238,589 1

Hash (cost=164,135.40..164,135.40 rows=152,550 width=24) (actual time=11,487.734..11,487.734 rows=238,589 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 15096kB
10. 11,410.895 11,410.895 ↓ 1.6 238,589 1

Seq Scan on invoice_51 i (cost=0.00..164,135.40 rows=152,550 width=24) (actual time=6,163.411..11,410.895 rows=238,589 loops=1)

  • Filter: (delivery AND is_active AND (date_create >= '2018-07-01 00:00:00'::timestamp without time zone) AND (invoice_type_id = ANY ('{200,201,202,203,204}'::integer[])))
  • Rows Removed by Filter: 2615841
11. 48.656 169.957 ↑ 1.0 188,494 1

Hash (cost=15,188.15..15,188.15 rows=196,595 width=12) (actual time=169.956..169.957 rows=188,494 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 10148kB
12. 121.301 121.301 ↑ 1.0 188,494 1

Seq Scan on goods_all g (cost=0.00..15,188.15 rows=196,595 width=12) (actual time=0.022..121.301 rows=188,494 loops=1)

  • Filter: (weight_netto IS NOT NULL)
  • Rows Removed by Filter: 36
13. 888.147 30,134.595 ↑ 8.6 112,882 1

HashAggregate (cost=254,521.50..264,232.98 rows=971,148 width=45) (actual time=30,080.924..30,134.595 rows=112,882 loops=1)

  • Group Key: ib_1.invoice_id, ib_1.program_id, ib_1.db_id, ib_1.is_active, i_1.date_create
14. 478.359 29,246.448 ↓ 1.3 1,267,812 1

Hash Join (cost=57,541.06..232,670.67 rows=971,148 width=37) (actual time=7,805.748..29,246.448 rows=1,267,812 loops=1)

  • Hash Cond: (ib_1.goods_id = g_1.id)
15. 1,028.553 28,619.960 ↓ 1.3 1,267,812 1

Hash Join (cost=39,895.47..201,671.42 rows=971,247 width=33) (actual time=7,657.193..28,619.960 rows=1,267,812 loops=1)

  • Hash Cond: ((ib_1.invoice_id = i_1.id) AND (ib_1.program_id = i_1.program_id) AND (ib_1.db_id = i_1.db_id))
16. 22,227.784 22,227.784 ↓ 1.0 4,335,042 1

Seq Scan on invoice_body_378 ib_1 (cost=0.00..103,325.05 rows=4,332,305 width=25) (actual time=54.288..22,227.784 rows=4,335,042 loops=1)

  • Filter: (is_active AND (invoice_id IS NOT NULL) AND (db_id IS NOT NULL) AND (program_id IS NOT NULL) AND (goods_id IS NOT NULL) AND (quantity IS NOT NULL))
17. 33.658 5,363.623 ↓ 1.1 112,882 1

Hash (cost=38,157.43..38,157.43 rows=99,317 width=24) (actual time=5,363.623..5,363.623 rows=112,882 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 7198kB
18. 5,329.965 5,329.965 ↓ 1.1 112,882 1

Seq Scan on invoice_378 i_1 (cost=0.00..38,157.43 rows=99,317 width=24) (actual time=0.055..5,329.965 rows=112,882 loops=1)

  • Filter: (delivery AND is_active AND (date_create >= '2018-07-01 00:00:00'::timestamp without time zone) AND (invoice_type_id = ANY ('{200,201,202,203,204}'::integer[])))
  • Rows Removed by Filter: 255263
19. 44.276 148.129 ↑ 1.0 188,494 1

Hash (cost=15,188.15..15,188.15 rows=196,595 width=12) (actual time=148.129..148.129 rows=188,494 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 10148kB
20. 103.853 103.853 ↑ 1.0 188,494 1

Seq Scan on goods_all g_1 (cost=0.00..15,188.15 rows=196,595 width=12) (actual time=0.017..103.853 rows=188,494 loops=1)

  • Filter: (weight_netto IS NOT NULL)
  • Rows Removed by Filter: 36
21. 20.254 4,157.243 ↑ 9.0 7,602 1

HashAggregate (cost=50,251.58..50,938.32 rows=68,674 width=45) (actual time=4,154.551..4,157.243 rows=7,602 loops=1)

  • Group Key: ib_2.invoice_id, ib_2.program_id, ib_2.db_id, ib_2.is_active, i_2.date_create
22. 8.752 4,136.989 ↑ 3.3 21,086 1

Hash Join (cost=21,692.27..48,706.41 rows=68,674 width=37) (actual time=3,190.909..4,136.989 rows=21,086 loops=1)

  • Hash Cond: (ib_2.goods_id = g_2.id)
23. 121.418 3,956.391 ↑ 3.3 21,086 1

Hash Join (cost=4,046.68..30,116.53 rows=68,681 width=33) (actual time=3,018.624..3,956.391 rows=21,086 loops=1)

  • Hash Cond: ((ib_2.invoice_id = i_2.id) AND (ib_2.program_id = i_2.program_id) AND (ib_2.db_id = i_2.db_id))
24. 3,789.058 3,789.058 ↑ 1.0 726,650 1

Seq Scan on invoice_body_376 ib_2 (cost=0.00..17,174.49 rows=729,649 width=25) (actual time=0.014..3,789.058 rows=726,650 loops=1)

  • Filter: (is_active AND (invoice_id IS NOT NULL) AND (db_id IS NOT NULL) AND (program_id IS NOT NULL) AND (goods_id IS NOT NULL) AND (quantity IS NOT NULL))
25. 2.158 45.915 ↓ 1.4 7,602 1

Hash (cost=3,948.91..3,948.91 rows=5,587 width=24) (actual time=45.915..45.915 rows=7,602 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 480kB
26. 43.757 43.757 ↓ 1.4 7,602 1

Seq Scan on invoice_376 i_2 (cost=0.00..3,948.91 rows=5,587 width=24) (actual time=26.020..43.757 rows=7,602 loops=1)

  • Filter: (delivery AND is_active AND (date_create >= '2018-07-01 00:00:00'::timestamp without time zone) AND (invoice_type_id = ANY ('{200,201,202,203,204}'::integer[])))
  • Rows Removed by Filter: 59792
27. 56.076 171.846 ↑ 1.0 188,494 1

Hash (cost=15,188.15..15,188.15 rows=196,595 width=12) (actual time=171.846..171.846 rows=188,494 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 10148kB
28. 115.770 115.770 ↑ 1.0 188,494 1

Seq Scan on goods_all g_2 (cost=0.00..15,188.15 rows=196,595 width=12) (actual time=0.008..115.770 rows=188,494 loops=1)

  • Filter: (weight_netto IS NOT NULL)
  • Rows Removed by Filter: 36
29. 1,959.731 116,379.815 ↓ 1.7 310,433 1

HashAggregate (cost=1,314,185.63..1,315,962.79 rows=177,716 width=45) (actual time=116,227.331..116,379.815 rows=310,433 loops=1)

  • Group Key: ib_3.invoice_id, ib_3.program_id, ib_3.db_id, ib_3.is_active, i_3.date_create
30. 938.005 114,420.084 ↓ 15.9 2,819,594 1

Hash Join (cost=183,011.46..1,310,187.02 rows=177,716 width=37) (actual time=86,464.533..114,420.084 rows=2,819,594 loops=1)

  • Hash Cond: (ib_3.goods_id = g_3.id)
31. 4,840.152 113,343.933 ↓ 15.9 2,819,594 1

Hash Join (cost=165,365.87..1,290,097.77 rows=177,734 width=33) (actual time=86,325.656..113,343.933 rows=2,819,594 loops=1)

  • Hash Cond: ((ib_3.invoice_id = i_3.id) AND (ib_3.program_id = i_3.program_id) AND (ib_3.db_id = i_3.db_id))
32. 92,883.287 92,883.287 ↑ 1.0 31,599,650 1

Seq Scan on invoice_body_167 ib_3 (cost=0.00..767,438.91 rows=31,601,391 width=25) (actual time=85.878..92,883.287 rows=31,599,650 loops=1)

  • Filter: (is_active AND (invoice_id IS NOT NULL) AND (db_id IS NOT NULL) AND (program_id IS NOT NULL) AND (goods_id IS NOT NULL) AND (quantity IS NOT NULL))
33. 142.890 15,620.494 ↓ 1.5 310,433 1

Hash (cost=161,789.56..161,789.56 rows=204,361 width=24) (actual time=15,620.493..15,620.494 rows=310,433 loops=1)

  • Buckets: 524288 (originally 262144) Batches: 1 (originally 1) Memory Usage: 21073kB
34. 15,477.604 15,477.604 ↓ 1.5 310,433 1

Seq Scan on invoice_167 i_3 (cost=0.00..161,789.56 rows=204,361 width=24) (actual time=10,192.770..15,477.604 rows=310,433 loops=1)

  • Filter: (delivery AND is_active AND (date_create >= '2018-07-01 00:00:00'::timestamp without time zone) AND (invoice_type_id = ANY ('{200,201,202,203,204}'::integer[])))
  • Rows Removed by Filter: 2206934
35. 39.998 138.146 ↑ 1.0 188,494 1

Hash (cost=15,188.15..15,188.15 rows=196,595 width=12) (actual time=138.146..138.146 rows=188,494 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 10148kB
36. 98.148 98.148 ↑ 1.0 188,494 1

Seq Scan on goods_all g_3 (cost=0.00..15,188.15 rows=196,595 width=12) (actual time=0.012..98.148 rows=188,494 loops=1)

  • Filter: (weight_netto IS NOT NULL)
  • Rows Removed by Filter: 36
37. 452.691 1,758.412 ↑ 7.3 78,609 1

HashAggregate (cost=168,319.09..174,078.67 rows=575,958 width=45) (actual time=1,722.710..1,758.412 rows=78,609 loops=1)

  • Group Key: ib_4.invoice_id, ib_4.program_id, ib_4.db_id, ib_4.is_active, i_4.date_create
38. 194.445 1,305.721 ↓ 1.2 696,161 1

Hash Join (cost=99,436.83..155,360.03 rows=575,958 width=37) (actual time=401.590..1,305.721 rows=696,161 loops=1)

  • Hash Cond: (ib_4.goods_id = g_4.id)
39. 343.967 969.964 ↓ 1.2 696,161 1

Hash Join (cost=81,791.24..129,794.80 rows=576,017 width=33) (actual time=259.457..969.964 rows=696,161 loops=1)

  • Hash Cond: ((ib_4.invoice_id = i_4.id) AND (ib_4.program_id = i_4.program_id) AND (ib_4.db_id = i_4.db_id))
40. 368.024 368.024 ↓ 1.0 1,137,632 1

Seq Scan on invoice_body_384 ib_4 (cost=0.00..29,655.89 rows=1,118,889 width=25) (actual time=0.011..368.024 rows=1,137,632 loops=1)

  • Filter: (is_active AND (invoice_id IS NOT NULL) AND (db_id IS NOT NULL) AND (program_id IS NOT NULL) AND (goods_id IS NOT NULL) AND (quantity IS NOT NULL))
41. 23.505 257.973 ↑ 6.6 78,609 1

Hash (cost=72,703.16..72,703.16 rows=519,319 width=24) (actual time=257.973..257.973 rows=78,609 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 8395kB
42. 234.468 234.468 ↑ 6.6 78,609 1

Seq Scan on invoice_384 i_4 (cost=0.00..72,703.16 rows=519,319 width=24) (actual time=8.579..234.468 rows=78,609 loops=1)

  • Filter: (delivery AND is_active AND (date_create >= '2018-07-01 00:00:00'::timestamp without time zone) AND (invoice_type_id = ANY ('{200,201,202,203,204}'::integer[])))
  • Rows Removed by Filter: 58770
43. 42.050 141.312 ↑ 1.0 188,494 1

Hash (cost=15,188.15..15,188.15 rows=196,595 width=12) (actual time=141.312..141.312 rows=188,494 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 10148kB
44. 99.262 99.262 ↑ 1.0 188,494 1

Seq Scan on goods_all g_4 (cost=0.00..15,188.15 rows=196,595 width=12) (actual time=0.016..99.262 rows=188,494 loops=1)

  • Filter: (weight_netto IS NOT NULL)
  • Rows Removed by Filter: 36
45. 897.699 78,798.843 ↓ 1.2 166,140 1

HashAggregate (cost=803,188.52..804,541.39 rows=135,287 width=45) (actual time=78,719.422..78,798.843 rows=166,140 loops=1)

  • Group Key: ib_5.invoice_id, ib_5.program_id, ib_5.db_id, ib_5.is_active, i_5.date_create
46. 422.629 77,901.144 ↓ 9.3 1,258,485 1

Hash Join (cost=125,669.51..800,144.56 rows=135,287 width=37) (actual time=50,058.985..77,901.144 rows=1,258,485 loops=1)

  • Hash Cond: (ib_5.goods_id = g_5.id)
47. 2,984.397 77,332.555 ↓ 9.3 1,258,485 1

Hash Join (cost=108,023.92..780,638.72 rows=135,301 width=33) (actual time=49,912.279..77,332.555 rows=1,258,485 loops=1)

  • Hash Cond: ((ib_5.invoice_id = i_5.id) AND (ib_5.program_id = i_5.program_id) AND (ib_5.db_id = i_5.db_id))
48. 66,960.366 66,960.366 ↑ 1.0 18,971,445 1

Seq Scan on invoice_body_98 ib_5 (cost=0.00..457,828.49 rows=18,971,849 width=25) (actual time=28.683..66,960.366 rows=18,971,445 loops=1)

  • Filter: (is_active AND (invoice_id IS NOT NULL) AND (db_id IS NOT NULL) AND (program_id IS NOT NULL) AND (goods_id IS NOT NULL) AND (quantity IS NOT NULL))
49. 63.155 7,387.792 ↓ 1.6 166,140 1

Hash (cost=106,226.64..106,226.64 rows=102,702 width=24) (actual time=7,387.792..7,387.792 rows=166,140 loops=1)

  • Buckets: 262144 (originally 131072) Batches: 1 (originally 1) Memory Usage: 11134kB
50. 7,324.637 7,324.637 ↓ 1.6 166,140 1

Seq Scan on invoice_98 i_5 (cost=0.00..106,226.64 rows=102,702 width=24) (actual time=6,892.776..7,324.637 rows=166,140 loops=1)

  • Filter: (delivery AND is_active AND (date_create >= '2018-07-01 00:00:00'::timestamp without time zone) AND (invoice_type_id = ANY ('{200,201,202,203,204}'::integer[])))
  • Rows Removed by Filter: 1674279
51. 41.307 145.960 ↑ 1.0 188,494 1

Hash (cost=15,188.15..15,188.15 rows=196,595 width=12) (actual time=145.959..145.960 rows=188,494 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 10148kB
52. 104.653 104.653 ↑ 1.0 188,494 1

Seq Scan on goods_all g_5 (cost=0.00..15,188.15 rows=196,595 width=12) (actual time=0.015..104.653 rows=188,494 loops=1)

  • Filter: (weight_netto IS NOT NULL)
  • Rows Removed by Filter: 36
53. 1,049.198 179,007.125 ↓ 3.2 420,918 1

GroupAggregate (cost=2,128,655.27..2,133,229.49 rows=130,692 width=45) (actual time=177,641.574..179,007.125 rows=420,918 loops=1)

  • Group Key: ib_6.invoice_id, ib_6.program_id, ib_6.db_id, ib_6.is_active, i_6.date_doc
54. 2,019.793 177,957.927 ↓ 18.3 2,386,085 1

Sort (cost=2,128,655.27..2,128,982.00 rows=130,692 width=37) (actual time=177,641.558..177,957.927 rows=2,386,085 loops=1)

  • Sort Key: ib_6.invoice_id, ib_6.program_id, ib_6.db_id, ib_6.is_active, i_6.date_doc
  • Sort Method: external merge Disk: 116616kB
55. 891.202 175,938.134 ↓ 18.3 2,386,085 1

Hash Join (cost=528,084.80..2,117,549.19 rows=130,692 width=37) (actual time=160,289.235..175,938.134 rows=2,386,085 loops=1)

  • Hash Cond: (ib_6.goods_id = g_6.id)
56. 7,572.932 174,899.983 ↓ 18.3 2,386,085 1

Hash Join (cost=510,439.21..2,098,106.54 rows=130,705 width=33) (actual time=160,141.261..174,899.983 rows=2,386,085 loops=1)

  • Hash Cond: ((ib_6.invoice_id = i_6.id) AND (ib_6.program_id = i_6.program_id) AND (ib_6.db_id = i_6.db_id))
57. 106,338.602 106,338.602 ↓ 1.0 45,065,047 1

Seq Scan on invoice_body_4 ib_6 (cost=0.00..1,079,615.66 rows=45,043,966 width=25) (actual time=23.651..106,338.602 rows=45,065,047 loops=1)

  • Filter: (is_active AND (invoice_id IS NOT NULL) AND (db_id IS NOT NULL) AND (program_id IS NOT NULL) AND (goods_id IS NOT NULL) AND (quantity IS NOT NULL))
58. 167.984 60,988.449 ↑ 1.1 420,918 1

Hash (cost=502,556.72..502,556.72 rows=450,428 width=24) (actual time=60,988.449..60,988.449 rows=420,918 loops=1)

  • Buckets: 524288 Batches: 1 Memory Usage: 27115kB
59. 59,665.356 60,820.465 ↑ 1.1 420,918 1

Bitmap Heap Scan on invoice_4 i_6 (cost=78,643.91..502,556.72 rows=450,428 width=24) (actual time=47,206.459..60,820.465 rows=420,918 loops=1)

  • Recheck Cond: (invoice_type_id = ANY ('{200,201,202,203,204}'::integer[]))
  • Filter: (is_active AND (date_create >= '2018-07-01 00:00:00'::timestamp without time zone))
  • Rows Removed by Filter: 4288870
  • Heap Blocks: exact=240689
60. 1,155.109 1,155.109 ↑ 1.0 4,760,039 1

Bitmap Index Scan on invoice_4_invoice_type_id_idx (cost=0.00..78,531.30 rows=4,825,750 width=0) (actual time=1,155.109..1,155.109 rows=4,760,039 loops=1)

  • Index Cond: (invoice_type_id = ANY ('{200,201,202,203,204}'::integer[]))
61. 47.314 146.949 ↑ 1.0 188,494 1

Hash (cost=15,188.15..15,188.15 rows=196,595 width=12) (actual time=146.949..146.949 rows=188,494 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 10148kB
62. 99.635 99.635 ↑ 1.0 188,494 1

Seq Scan on goods_all g_6 (cost=0.00..15,188.15 rows=196,595 width=12) (actual time=0.013..99.635 rows=188,494 loops=1)

  • Filter: (weight_netto IS NOT NULL)
  • Rows Removed by Filter: 36
63. 510.291 7,525.848 ↑ 4.1 138,395 1

HashAggregate (cost=130,699.89..136,374.88 rows=567,499 width=45) (actual time=7,428.749..7,525.848 rows=138,395 loops=1)

  • Group Key: ib_7.invoice_id, ib_7.program_id, ib_7.db_id, ib_7.is_active, i_7.date_doc
64. 204.729 7,015.557 ↓ 1.1 600,218 1

Hash Join (cost=49,969.96..117,931.16 rows=567,499 width=37) (actual time=679.951..7,015.557 rows=600,218 loops=1)

  • Hash Cond: (ib_7.goods_id = g_7.id)
65. 443.935 6,662.597 ↓ 1.1 600,218 1

Hash Join (cost=32,324.37..92,482.24 rows=567,557 width=33) (actual time=531.325..6,662.597 rows=600,218 loops=1)

  • Hash Cond: ((ib_7.invoice_id = i_7.id) AND (ib_7.program_id = i_7.program_id) AND (ib_7.db_id = i_7.db_id))
66. 5,928.875 5,928.875 ↑ 1.0 1,570,217 1

Seq Scan on invoice_body_387 ib_7 (cost=0.00..36,808.79 rows=1,570,979 width=25) (actual time=241.157..5,928.875 rows=1,570,217 loops=1)

  • Filter: (is_active AND (invoice_id IS NOT NULL) AND (db_id IS NOT NULL) AND (program_id IS NOT NULL) AND (goods_id IS NOT NULL) AND (quantity IS NOT NULL))
67. 43.417 289.787 ↑ 1.1 138,395 1

Hash (cost=29,722.45..29,722.45 rows=148,681 width=24) (actual time=289.787..289.787 rows=138,395 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 9617kB
68. 246.370 246.370 ↑ 1.1 138,395 1

Seq Scan on invoice_387 i_7 (cost=0.00..29,722.45 rows=148,681 width=24) (actual time=0.026..246.370 rows=138,395 loops=1)

  • Filter: (is_active AND (date_create >= '2018-07-01 00:00:00'::timestamp without time zone) AND (invoice_type_id = ANY ('{200,201,202,203,204}'::integer[])))
  • Rows Removed by Filter: 244858
69. 45.856 148.231 ↑ 1.0 188,494 1

Hash (cost=15,188.15..15,188.15 rows=196,595 width=12) (actual time=148.231..148.231 rows=188,494 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 10148kB
70. 102.375 102.375 ↑ 1.0 188,494 1

Seq Scan on goods_all g_7 (cost=0.00..15,188.15 rows=196,595 width=12) (actual time=0.046..102.375 rows=188,494 loops=1)

  • Filter: (weight_netto IS NOT NULL)
  • Rows Removed by Filter: 36
Planning time : 1,152.976 ms
Execution time : 580,389.802 ms