explain.depesz.com

PostgreSQL's explain analyze made readable

Result: knqZ

Settings
# exclusive inclusive rows x rows loops node
1. 110.790 4,139.993 ↓ 1.1 141,859 1

WindowAgg (cost=355,759.54..385,903.02 rows=133,971 width=315) (actual time=3,977.541..4,139.993 rows=141,859 loops=1)

2. 261.294 4,029.203 ↓ 1.1 141,859 1

Sort (cost=355,759.54..356,094.47 rows=133,971 width=266) (actual time=3,977.525..4,029.203 rows=141,859 loops=1)

  • Sort Key: billing_invoice.user_id, billing_invoice.created
  • Sort Method: external merge Disk: 27,320kB
3. 97.098 3,767.909 ↓ 1.1 141,859 1

WindowAgg (cost=300,264.21..334,426.81 rows=133,971 width=266) (actual time=3,559.513..3,767.909 rows=141,859 loops=1)

4. 73.769 3,670.811 ↓ 1.1 141,859 1

Group (cost=300,264.21..320,359.86 rows=133,971 width=258) (actual time=3,559.496..3,670.811 rows=141,859 loops=1)

  • Group Key: billing_invoice.id, billing_invoice.created, billing_invoice.backend, billing_invoice.payed, billing_invoice.cancelled, billing_invoice.is_proforma, billing_product.id, billing_product.title, billing_product.credits, billing_invoiceproducts.qty, (CASE WHEN ((accounts_sellervat.number IS NOT NULL) AND (accounts_sellervat.country_id <> 74)) THEN CASE WHEN (billing_product.id = ANY ('{50,138,230}'::integer[])) THEN ((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) ELSE (((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) / 1.24) END ELSE CASE WHEN (billing_product.id = ANY ('{50,138,230}'::integer[])) THEN (((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) * 1.24) ELSE ((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) END END), billing_invoice.user_id, (CASE WHEN (billing_invoice.created_by_id IS NULL) THEN billing_invoice.user_id ELSE billing_invoice.created_by_id END), (CASE WHEN (sales_reps.id IS NOT NULL) THEN concat(sales_reps.first_name, ' ', sales_reps.last_name) ELSE NULL::text END), (CASE WHEN (billing_unattendedregistration_invoices.invoice_id IS NOT NULL) THEN 1 ELSE 0 END), billing_invoice.confirmed, billing_invoice.uid, paid_invoices.created, job_ids.job_ids, (CASE WHEN ((accounts_sellervat.number IS NOT NULL) AND (accounts_sellervat.country_id <> 74)) THEN CASE WHEN (billing_product.id = ANY ('{50,138,230}'::integer[])) THEN ((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) ELSE (((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) / 1.24) END ELSE CASE WHEN (billing_product.id = ANY ('{50,138,230}'::integer[])) THEN ((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) ELSE (((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) / 1.24) END END), billing_product.bids, c.category_id
5. 198.306 3,597.042 ↓ 1.1 141,859 1

Sort (cost=300,264.21..300,599.14 rows=133,971 width=258) (actual time=3,559.490..3,597.042 rows=141,859 loops=1)

  • Sort Key: billing_invoice.id, billing_invoice.created, billing_invoice.backend, billing_invoice.payed, billing_invoice.cancelled, billing_invoice.is_proforma, billing_product.id, billing_product.title, billing_product.credits, billing_invoiceproducts.qty, (CASE WHEN ((accounts_sellervat.number IS NOT NULL) AND (accounts_sellervat.country_id <> 74)) THEN CASE WHEN (billing_product.id = ANY ('{50,138,230}'::integer[])) THEN ((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) ELSE (((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) / 1.24) END ELSE CASE WHEN (billing_product.id = ANY ('{50,138,230}'::integer[])) THEN (((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) * 1.24) ELSE ((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) END END), billing_invoice.user_id, (CASE WHEN (billing_invoice.created_by_id IS NULL) THEN billing_invoice.user_id ELSE billing_invoice.created_by_id END), (CASE WHEN (sales_reps.id IS NOT NULL) THEN concat(sales_reps.first_name, ' ', sales_reps.last_name) ELSE NULL::text END), (CASE WHEN (billing_unattendedregistration_invoices.invoice_id IS NOT NULL) THEN 1 ELSE 0 END), billing_invoice.confirmed, billing_invoice.uid, paid_invoices.created, job_ids.job_ids, (CASE WHEN ((accounts_sellervat.number IS NOT NULL) AND (accounts_sellervat.country_id <> 74)) THEN CASE WHEN (billing_product.id = ANY ('{50,138,230}'::integer[])) THEN ((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) ELSE (((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) / 1.24) END ELSE CASE WHEN (billing_product.id = ANY ('{50,138,230}'::integer[])) THEN ((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) ELSE (((billing_product.price_raw * (billing_invoiceproducts.qty)::numeric) * billing_invoice.discount) / 1.24) END END), billing_product.bids, c.category_id
  • Sort Method: external merge Disk: 25,664kB
6. 250.108 3,398.736 ↓ 1.1 141,859 1

Hash Left Join (cost=244,513.40..279,200.03 rows=133,971 width=258) (actual time=2,586.902..3,398.736 rows=141,859 loops=1)

  • Hash Cond: (billing_invoice.id = c.invoice_id)
7. 68.440 2,235.941 ↓ 1.1 141,859 1

Hash Left Join (cost=187,634.31..207,415.50 rows=133,971 width=191) (actual time=1,674.248..2,235.941 rows=141,859 loops=1)

  • Hash Cond: (billing_invoice.id = billing_invoice_1.id)
8. 62.539 2,066.912 ↓ 1.1 141,859 1

Hash Left Join (cost=179,892.73..198,539.05 rows=133,971 width=183) (actual time=1,573.011..2,066.912 rows=141,859 loops=1)

  • Hash Cond: (billing_invoice.id = job_ids.invoice_id)
9. 53.579 778.389 ↓ 1.1 141,859 1

Hash Left Join (cost=51,836.16..70,130.80 rows=133,971 width=151) (actual time=347.115..778.389 rows=141,859 loops=1)

  • Hash Cond: (accounts_duser.id = accounts_sellervat.user_id)
10. 53.670 721.699 ↓ 1.1 141,859 1

Hash Left Join (cost=51,546.21..69,308.75 rows=133,971 width=141) (actual time=343.934..721.699 rows=141,859 loops=1)

  • Hash Cond: (billing_invoice.user_id = accounts_duser.id)
11. 38.984 516.528 ↓ 1.1 141,859 1

Hash Left Join (cost=28,645.78..46,056.65 rows=133,971 width=137) (actual time=192.167..516.528 rows=141,859 loops=1)

  • Hash Cond: (billing_invoice.id = billing_unattendedregistration_invoices.invoice_id)
12. 40.495 476.924 ↓ 1.1 141,859 1

Hash Left Join (cost=28,579.64..45,466.16 rows=133,971 width=133) (actual time=191.523..476.924 rows=141,859 loops=1)

  • Hash Cond: (billing_invoiceproducts.product_id = billing_product.id)
13. 78.038 436.279 ↓ 1.1 141,859 1

Hash Left Join (cost=28,565.97..45,094.89 rows=133,971 width=79) (actual time=191.348..436.279 rows=141,859 loops=1)

  • Hash Cond: (billing_invoice.created_by_id = sales_reps.id)
14. 53.727 167.289 ↓ 1.1 141,859 1

Merge Left Join (cost=0.89..11,003.14 rows=133,971 width=46) (actual time=0.036..167.289 rows=141,859 loops=1)

  • Merge Cond: (billing_invoice.id = billing_invoiceproducts.invoice_id)
15. 71.422 71.422 ↓ 1.0 135,695 1

Index Scan using billing_invoice_idx on billing_invoice (cost=0.42..5,681.31 rows=133,971 width=38) (actual time=0.013..71.422 rows=135,695 loops=1)

  • Filter: (((backend)::text <> 'manual'::text) OR (((backend)::text = 'manual'::text) AND (created_by_id IS NOT NULL)))
  • Rows Removed by Filter: 8,315
16. 42.140 42.140 ↑ 1.0 140,994 1

Index Scan using billing_invoiceproducts_invoice_id_idx on billing_invoiceproducts (cost=0.42..3,323.69 rows=141,126 width=12) (actual time=0.008..42.140 rows=140,994 loops=1)

17. 86.703 190.952 ↑ 1.0 355,658 1

Hash (cost=21,236.59..21,236.59 rows=360,759 width=33) (actual time=190.951..190.952 rows=355,658 loops=1)

  • Buckets: 262,144 Batches: 4 Memory Usage: 7,841kB
18. 104.249 104.249 ↑ 1.0 355,658 1

Seq Scan on accounts_duser sales_reps (cost=0.00..21,236.59 rows=360,759 width=33) (actual time=0.010..104.249 rows=355,658 loops=1)

19. 0.054 0.150 ↑ 1.0 252 1

Hash (cost=10.52..10.52 rows=252 width=58) (actual time=0.150..0.150 rows=252 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 32kB
20. 0.096 0.096 ↑ 1.0 252 1

Seq Scan on billing_product (cost=0.00..10.52 rows=252 width=58) (actual time=0.012..0.096 rows=252 loops=1)

21. 0.307 0.620 ↑ 1.0 2,362 1

Hash (cost=36.62..36.62 rows=2,362 width=4) (actual time=0.619..0.620 rows=2,362 loops=1)

  • Buckets: 4,096 Batches: 1 Memory Usage: 116kB
22. 0.313 0.313 ↑ 1.0 2,362 1

Seq Scan on billing_unattendedregistration_invoices (cost=0.00..36.62 rows=2,362 width=4) (actual time=0.008..0.313 rows=2,362 loops=1)

23. 11.636 151.501 ↑ 1.0 60,236 1

Hash (cost=22,138.49..22,138.49 rows=60,955 width=4) (actual time=151.500..151.501 rows=60,236 loops=1)

  • Buckets: 65,536 Batches: 1 Memory Usage: 2,630kB
24. 139.865 139.865 ↑ 1.0 60,236 1

Seq Scan on accounts_duser (cost=0.00..22,138.49 rows=60,955 width=4) (actual time=0.010..139.865 rows=60,236 loops=1)

  • Filter: (favorite_category_id <> 354)
  • Rows Removed by Filter: 295,422
25. 1.439 3.111 ↓ 1.0 7,999 1

Hash (cost=189.98..189.98 rows=7,998 width=18) (actual time=3.110..3.111 rows=7,999 loops=1)

  • Buckets: 8,192 Batches: 1 Memory Usage: 471kB
26. 1.672 1.672 ↓ 1.0 7,999 1

Seq Scan on accounts_sellervat (cost=0.00..189.98 rows=7,998 width=18) (actual time=0.028..1.672 rows=7,999 loops=1)

27. 6.318 1,225.984 ↓ 181.5 36,308 1

Hash (cost=128,054.07..128,054.07 rows=200 width=36) (actual time=1,225.870..1,225.984 rows=36,308 loops=1)

  • Buckets: 65,536 (originally 1024) Batches: 1 (originally 1) Memory Usage: 2,715kB
28. 4.480 1,219.666 ↓ 181.5 36,308 1

Subquery Scan on job_ids (cost=128,049.57..128,054.07 rows=200 width=36) (actual time=1,198.489..1,219.666 rows=36,308 loops=1)

29. 79.256 1,215.186 ↓ 181.5 36,308 1

HashAggregate (cost=128,049.57..128,052.07 rows=200 width=36) (actual time=1,198.487..1,215.186 rows=36,308 loops=1)

  • Group Key: billing_invoice_2.id
30. 24.244 1,135.930 ↑ 1.2 118,258 1

Group (cost=114,873.86..125,232.11 rows=140,873 width=8) (actual time=1,023.547..1,135.930 rows=118,258 loops=1)

  • Group Key: jobs_job.id, billing_invoice_2.id
31. 54.202 1,111.686 ↓ 1.8 148,257 1

Gather Merge (cost=114,873.86..124,817.78 rows=82,866 width=8) (actual time=1,023.545..1,111.686 rows=148,257 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
32. 22.294 1,057.484 ↑ 1.1 74,128 2 / 2

Group (cost=113,873.85..114,495.34 rows=82,866 width=8) (actual time=1,018.377..1,057.484 rows=74,128 loops=2)

  • Group Key: jobs_job.id, billing_invoice_2.id
33. 72.225 1,035.190 ↓ 1.6 135,722 2 / 2

Sort (cost=113,873.85..114,081.01 rows=82,866 width=8) (actual time=1,018.372..1,035.190 rows=135,722 loops=2)

  • Sort Key: jobs_job.id, billing_invoice_2.id
  • Sort Method: quicksort Memory: 10,178kB
34. 0.000 962.965 ↓ 1.6 135,722 2 / 2

Nested Loop Left Join (cost=4,208.89..107,104.32 rows=82,866 width=8) (actual time=37.168..962.965 rows=135,722 loops=2)

35. 116.602 572.984 ↓ 1.6 135,722 2 / 2

Nested Loop Left Join (cost=4,208.47..65,158.79 rows=82,866 width=8) (actual time=37.124..572.984 rows=135,722 loops=2)

36. 80.330 184.938 ↓ 1.6 135,722 2 / 2

Hash Join (cost=4,208.04..27,147.82 rows=82,866 width=8) (actual time=37.083..184.938 rows=135,722 loops=2)

  • Hash Cond: (accounting_moneyflow.invoice_id = billing_invoice_2.id)
37. 68.201 68.201 ↑ 1.2 596,649 2 / 2

Parallel Seq Scan on accounting_moneyflow (cost=0.00..21,097.22 rows=701,922 width=8) (actual time=0.011..68.201 rows=596,649 loops=2)

38. 12.786 36.407 ↑ 1.0 67,414 2 / 2

Hash (cost=3,357.74..3,357.74 rows=68,024 width=4) (actual time=36.407..36.407 rows=67,414 loops=2)

  • Buckets: 131,072 Batches: 1 Memory Usage: 3,395kB
39. 23.621 23.621 ↑ 1.0 67,414 2 / 2

Index Scan using billing_invoice_is_proforma_idx on billing_invoice billing_invoice_2 (cost=0.42..3,357.74 rows=68,024 width=4) (actual time=0.037..23.621 rows=67,414 loops=2)

  • Index Cond: (is_proforma = true)
  • Filter: (is_proforma IS TRUE)
40. 271.444 271.444 ↑ 1.0 1 271,444 / 2

Index Scan using bids_bid_idx on bids_bid (cost=0.42..0.46 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=271,444)

  • Index Cond: (accounting_moneyflow.object_pk = id)
41. 407.166 407.166 ↑ 1.0 1 271,444 / 2

Index Only Scan using jobs_job_idx on jobs_job (cost=0.42..0.51 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=271,444)

  • Index Cond: (id = bids_bid.job_id)
  • Heap Fetches: 142,555
42. 15.726 100.589 ↑ 1.0 67,414 1

Hash (cost=6,891.28..6,891.28 rows=68,024 width=12) (actual time=100.587..100.589 rows=67,414 loops=1)

  • Buckets: 131,072 Batches: 1 Memory Usage: 3,892kB
43. 20.372 84.863 ↑ 1.0 67,414 1

Merge Left Join (cost=0.84..6,891.28 rows=68,024 width=12) (actual time=1.142..84.863 rows=67,414 loops=1)

  • Merge Cond: (billing_invoice_1.id = paid_invoices.proforma_id)
44. 44.433 44.433 ↑ 1.0 67,414 1

Index Scan using billing_invoice_idx on billing_invoice billing_invoice_1 (cost=0.42..4,960.87 rows=68,024 width=4) (actual time=1.128..44.433 rows=67,414 loops=1)

  • Filter: (is_proforma IS TRUE)
  • Rows Removed by Filter: 76,596
45. 20.058 20.058 ↑ 3.4 42,451 1

Index Scan using billing_invoice_proforma_id_idx on billing_invoice paid_invoices (cost=0.42..4,992.52 rows=144,088 width=12) (actual time=0.010..20.058 rows=42,451 loops=1)

46. 3.865 912.687 ↓ 205.8 25,932 1

Hash (cost=56,877.51..56,877.51 rows=126 width=8) (actual time=912.613..912.687 rows=25,932 loops=1)

  • Buckets: 32,768 (originally 1024) Batches: 1 (originally 1) Memory Usage: 1,269kB
47. 3.709 908.822 ↓ 205.8 25,932 1

Subquery Scan on c (cost=53,463.87..56,877.51 rows=126 width=8) (actual time=809.492..908.822 rows=25,932 loops=1)

  • Filter: (c.row_number = 1)
  • Rows Removed by Filter: 6,171
48. 14.054 905.113 ↓ 1.3 32,103 1

WindowAgg (cost=53,463.87..56,562.13 rows=25,231 width=16) (actual time=809.490..905.113 rows=32,103 loops=1)

49. 3.099 891.059 ↓ 1.3 32,103 1

Subquery Scan on a (cost=53,463.87..56,183.66 rows=25,231 width=8) (actual time=809.484..891.059 rows=32,103 loops=1)

50. 31.068 887.960 ↓ 1.3 32,103 1

Finalize GroupAggregate (cost=53,463.87..55,931.35 rows=25,231 width=40) (actual time=809.483..887.960 rows=32,103 loops=1)

  • Group Key: billing_invoice_3.id, categories_category.id
  • Filter: (sum(accounting_moneyflow_1.amount) <> '0'::numeric)
  • Rows Removed by Filter: 12
51. 22.028 856.892 ↓ 3.0 44,367 1

Gather Merge (cost=53,463.87..55,467.54 rows=14,842 width=40) (actual time=809.467..856.892 rows=44,367 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
52. 25.172 834.864 ↓ 1.5 22,184 2 / 2

Partial GroupAggregate (cost=52,463.86..52,797.81 rows=14,842 width=40) (actual time=804.455..834.864 rows=22,184 loops=2)

  • Group Key: billing_invoice_3.id, categories_category.id
53. 32.112 809.692 ↓ 4.6 67,570 2 / 2

Sort (cost=52,463.86..52,500.97 rows=14,842 width=12) (actual time=804.433..809.692 rows=67,570 loops=2)

  • Sort Key: billing_invoice_3.id, categories_category.id
  • Sort Method: quicksort Memory: 6,417kB
54. 16.386 777.580 ↓ 4.6 67,570 2 / 2

Hash Left Join (cost=7,273.24..51,435.51 rows=14,842 width=12) (actual time=77.969..777.580 rows=67,570 loops=2)

  • Hash Cond: (categories_categoryform.category_id = categories_category.id)
55. 20.459 761.063 ↓ 4.6 67,570 2 / 2

Hash Join (cost=7,259.22..51,382.11 rows=14,842 width=12) (actual time=77.816..761.063 rows=67,570 loops=2)

  • Hash Cond: (jobs_job_1.category_form_id = categories_categoryform.id)
56. 46.042 733.191 ↓ 4.3 67,760 2 / 2

Nested Loop (cost=6,521.87..50,603.62 rows=15,667 width=12) (actual time=70.224..733.191 rows=67,760 loops=2)

57. 22.353 483.871 ↓ 4.3 67,760 2 / 2

Nested Loop (cost=6,521.44..42,673.22 rows=15,667 width=12) (actual time=70.190..483.871 rows=67,760 loops=2)

58. 34.253 258.239 ↓ 4.3 67,760 2 / 2

Hash Join (cost=6,521.02..35,232.84 rows=15,667 width=12) (actual time=70.158..258.239 rows=67,760 loops=2)

  • Hash Cond: (accounting_moneyflow_1.invoice_id = billing_invoice_3.id)
59. 154.018 154.018 ↑ 3.0 116,192 2 / 2

Parallel Seq Scan on accounting_moneyflow accounting_moneyflow_1 (cost=0.00..27,239.04 rows=350,961 width=12) (actual time=0.013..154.018 rows=116,192 loops=2)

  • Filter: CASE WHEN ((action)::text = ANY ('{success,penalty,acquisition}'::text[])) THEN (amount < '0'::numeric) ELSE (amount > '0'::numeric) END
  • Rows Removed by Filter: 480,458
60. 5.730 69.968 ↓ 1.2 30,958 2 / 2

Hash (cost=6,199.49..6,199.49 rows=25,722 width=8) (actual time=69.964..69.968 rows=30,958 loops=2)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,466kB
61. 3.066 64.238 ↓ 1.2 30,958 2 / 2

Nested Loop (cost=4,208.61..6,199.49 rows=25,722 width=8) (actual time=35.574..64.238 rows=30,958 loops=2)

62. 0.030 0.030 ↑ 1.0 1 2 / 2

Index Only Scan using billing_product_idx on billing_product billing_product_1 (cost=0.14..2.36 rows=1 width=4) (actual time=0.028..0.030 rows=1 loops=2)

  • Index Cond: (id = 138)
  • Heap Fetches: 1
63. 15.971 61.142 ↓ 1.2 30,958 2 / 2

Hash Join (cost=4,208.46..5,939.91 rows=25,722 width=12) (actual time=35.543..61.142 rows=30,958 loops=2)

  • Hash Cond: (billing_invoiceproducts_1.invoice_id = billing_invoice_3.id)
64. 10.290 10.290 ↓ 1.0 54,628 2 / 2

Index Scan using billing_invoiceproducts_product_id_idx on billing_invoiceproducts billing_invoiceproducts_1 (cost=0.42..1,588.85 rows=54,484 width=8) (actual time=0.027..10.290 rows=54,628 loops=2)

  • Index Cond: (product_id = 138)
65. 11.725 34.881 ↑ 1.0 67,414 2 / 2

Hash (cost=3,357.74..3,357.74 rows=68,024 width=4) (actual time=34.880..34.881 rows=67,414 loops=2)

  • Buckets: 131,072 Batches: 1 Memory Usage: 3,395kB
66. 23.156 23.156 ↑ 1.0 67,414 2 / 2

Index Scan using billing_invoice_is_proforma_idx on billing_invoice billing_invoice_3 (cost=0.42..3,357.74 rows=68,024 width=4) (actual time=0.038..23.156 rows=67,414 loops=2)

  • Index Cond: (is_proforma = true)
  • Filter: (is_proforma IS TRUE)
67. 203.279 203.279 ↑ 1.0 1 135,519 / 2

Index Scan using bids_bid_idx on bids_bid bids_bid_1 (cost=0.42..0.47 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=135,519)

  • Index Cond: (id = accounting_moneyflow_1.object_pk)
68. 203.279 203.279 ↑ 1.0 1 135,519 / 2

Index Scan using jobs_job_idx on jobs_job jobs_job_1 (cost=0.42..0.51 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=135,519)

  • Index Cond: (id = bids_bid_1.job_id)
69. 3.420 7.413 ↑ 1.0 23,481 2 / 2

Hash (cost=443.84..443.84 rows=23,481 width=8) (actual time=7.412..7.413 rows=23,481 loops=2)

  • Buckets: 32,768 Batches: 1 Memory Usage: 1,174kB
70. 3.993 3.993 ↑ 1.0 23,481 2 / 2

Seq Scan on categories_categoryform (cost=0.00..443.84 rows=23,481 width=8) (actual time=0.024..3.993 rows=23,481 loops=2)

  • Filter: (category_id <> ALL ('{356,354}'::integer[]))
  • Rows Removed by Filter: 1,306
71. 0.055 0.131 ↑ 1.0 401 2 / 2

Hash (cost=9.01..9.01 rows=401 width=4) (actual time=0.130..0.131 rows=401 loops=2)

  • Buckets: 1,024 Batches: 1 Memory Usage: 23kB
72. 0.076 0.076 ↑ 1.0 401 2 / 2

Seq Scan on categories_category (cost=0.00..9.01 rows=401 width=4) (actual time=0.024..0.076 rows=401 loops=2)

Planning time : 6.933 ms
Execution time : 4,154.702 ms