explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Tlkm

Settings
# exclusive inclusive rows x rows loops node
1. 74.981 40,914.950 ↓ 536.5 107,293 1

Unique (cost=6,214,847.12..6,239,002.60 rows=200 width=536) (actual time=40,746.226..40,914.950 rows=107,293 loops=1)

2.          

CTE sell_transactions_with_cellphone

3. 249.268 1,847.229 ↓ 2.0 107,293 1

Merge Join (cost=69.86..182,138.47 rows=53,886 width=146) (actual time=756.261..1,847.229 rows=107,293 loops=1)

  • Merge Cond: (t_2.cellphone_id = c_1.id)
4. 1,044.136 1,044.136 ↑ 4.3 107,362 1

Index Scan using transactions_cellphone_id_index on transactions t_2 (cost=0.43..627,774.19 rows=459,763 width=115) (actual time=445.454..1,044.136 rows=107,362 loops=1)

  • Filter: ((deleted_at IS NULL) AND (transaction_type_id = 1) AND (created_at > (now() - '5 mons'::interval month)))
  • Rows Removed by Filter: 595745
5. 553.825 553.825 ↓ 1.0 715,930 1

Index Scan using cellphones_pkey on cellphones c_1 (cost=0.42..89,472.27 rows=710,076 width=39) (actual time=0.014..553.825 rows=715,930 loops=1)

  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 163338
6. 945.591 40,839.969 ↑ 21.1 229,061 1

Sort (cost=6,032,708.65..6,044,786.39 rows=4,831,095 width=536) (actual time=40,746.224..40,839.969 rows=229,061 loops=1)

  • Sort Key: t.id, rr1.id, th_por_entrar_return.id, th_fin.id, dh_em_transito.id
  • Sort Method: external sort Disk: 94936kB
7. 1,321.058 39,894.378 ↑ 21.1 229,061 1

Merge Right Join (cost=1,810,744.95..2,028,726.95 rows=4,831,095 width=536) (actual time=38,290.737..39,894.378 rows=229,061 loops=1)

  • Merge Cond: (t_1.id = t.id)
8. 16.139 1,055.324 ↑ 1.1 10,043 1

GroupAggregate (cost=146,351.65..146,580.13 rows=11,424 width=19) (actual time=1,034.744..1,055.324 rows=10,043 loops=1)

  • Group Key: t_1.id
9. 10.112 1,039.185 ↓ 1.0 11,911 1

Sort (cost=146,351.65..146,380.21 rows=11,424 width=19) (actual time=1,034.731..1,039.185 rows=11,911 loops=1)

  • Sort Key: t_1.id
  • Sort Method: quicksort Memory: 1146kB
10. 5.879 1,029.073 ↓ 1.0 11,911 1

Hash Join (cost=139,850.74..145,581.68 rows=11,424 width=19) (actual time=965.403..1,029.073 rows=11,911 loops=1)

  • Hash Cond: (t_r.return_reason_id = r_1.id)
11. 80.446 1,023.124 ↓ 1.0 11,911 1

Hash Join (cost=139,846.41..145,420.28 rows=11,424 width=8) (actual time=965.306..1,023.124 rows=11,911 loops=1)

  • Hash Cond: (t_r.transaction_id = t_1.id)
12. 39.003 39.003 ↓ 1.0 120,217 1

Seq Scan on transaction_return_reasons t_r (cost=0.00..1,884.07 rows=115,807 width=8) (actual time=0.018..39.003 rows=120,217 loops=1)

13. 113.515 903.675 ↑ 1.6 297,239 1

Hash (cost=132,283.96..132,283.96 rows=460,916 width=4) (actual time=903.675..903.675 rows=297,239 loops=1)

  • Buckets: 16384 Batches: 8 Memory Usage: 1317kB
14. 790.160 790.160 ↑ 1.6 297,239 1

Index Scan using transactions_created_at_index on transactions t_1 (cost=0.44..132,283.96 rows=460,916 width=4) (actual time=0.181..790.160 rows=297,239 loops=1)

  • Index Cond: (created_at > (now() - '5 mons'::interval month))
  • Filter: (transaction_type_id = 1)
  • Rows Removed by Filter: 585055
15. 0.026 0.070 ↑ 1.0 59 1

Hash (cost=3.59..3.59 rows=59 width=19) (actual time=0.070..0.070 rows=59 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 4kB
16. 0.044 0.044 ↑ 1.0 59 1

Seq Scan on return_reasons r_1 (cost=0.00..3.59 rows=59 width=19) (actual time=0.005..0.044 rows=59 loops=1)

17. 112.041 37,517.996 ↓ 2.7 229,061 1

Materialize (cost=1,664,393.30..1,664,816.19 rows=84,578 width=504) (actual time=37,255.814..37,517.996 rows=229,061 loops=1)

18. 875.270 37,405.955 ↓ 2.7 229,061 1

Sort (cost=1,664,393.30..1,664,604.75 rows=84,578 width=504) (actual time=37,255.810..37,405.955 rows=229,061 loops=1)

  • Sort Key: t.id
  • Sort Method: external merge Disk: 92944kB
19. 227.386 36,530.685 ↓ 2.7 229,061 1

Nested Loop Left Join (cost=1,507,029.01..1,638,389.44 rows=84,578 width=504) (actual time=32,581.140..36,530.685 rows=229,061 loops=1)

20. 142.028 34,699.872 ↓ 2.7 229,061 1

Hash Left Join (cost=1,507,028.59..1,595,766.78 rows=84,578 width=479) (actual time=32,580.016..34,699.872 rows=229,061 loops=1)

  • Hash Cond: (rr2.reviewer_id = rw2.id)
21. 159.613 34,557.791 ↓ 2.7 229,061 1

Hash Left Join (cost=1,507,022.23..1,595,191.24 rows=84,578 width=479) (actual time=32,579.956..34,557.791 rows=229,061 loops=1)

  • Hash Cond: (rr1.reviewer_id = rw1.id)
22. 1,499.754 34,398.111 ↓ 2.7 229,061 1

Hash Right Join (cost=1,507,015.86..1,594,615.70 rows=84,578 width=479) (actual time=32,579.872..34,398.111 rows=229,061 loops=1)

  • Hash Cond: (rr2.revision_id = r.id)
  • Join Filter: (rr1.id < rr2.id)
  • Rows Removed by Join Filter: 284748
23. 524.500 524.500 ↓ 1.0 1,669,984 1

Seq Scan on revision_reviewers rr2 (cost=0.00..48,096.32 rows=1,604,932 width=24) (actual time=0.019..524.500 rows=1,669,984 loops=1)

  • Filter: (deleted_at IS NULL)
24. 433.444 32,373.857 ↓ 2.7 229,061 1

Hash (cost=1,500,754.64..1,500,754.64 rows=84,578 width=475) (actual time=32,373.857..32,373.857 rows=229,061 loops=1)

  • Buckets: 1024 Batches: 32 (originally 16) Memory Usage: 13681kB
25. 141.225 31,940.413 ↓ 2.7 229,061 1

Hash Left Join (cost=1,423,028.28..1,500,754.64 rows=84,578 width=475) (actual time=20,618.847..31,940.413 rows=229,061 loops=1)

  • Hash Cond: (mn.external_repairer_id = er.id)
26. 14,691.899 31,799.170 ↓ 2.7 229,061 1

Hash Right Join (cost=1,423,026.88..1,500,413.48 rows=84,578 width=467) (actual time=20,618.806..31,799.170 rows=229,061 loops=1)

  • Hash Cond: (rr1.revision_id = r.id)
27. 552.257 552.257 ↓ 1.0 1,669,984 1

Seq Scan on revision_reviewers rr1 (cost=0.00..48,096.32 rows=1,604,932 width=24) (actual time=0.011..552.257 rows=1,669,984 loops=1)

  • Filter: (deleted_at IS NULL)
28. 1,190.218 16,555.014 ↓ 2.2 134,145 1

Hash (cost=1,418,637.17..1,418,637.17 rows=61,737 width=451) (actual time=16,555.014..16,555.014 rows=134,145 loops=1)

  • Buckets: 1024 Batches: 32768 (originally 8) Memory Usage: 11070kB
29. 165.078 15,364.796 ↓ 2.2 134,145 1

Nested Loop Left Join (cost=670,036.62..1,418,637.17 rows=61,737 width=451) (actual time=8,099.593..15,364.796 rows=134,145 loops=1)

30. 86.312 14,394.848 ↓ 2.2 134,145 1

Nested Loop Left Join (cost=670,036.19..1,385,235.08 rows=61,737 width=425) (actual time=8,099.574..14,394.848 rows=134,145 loops=1)

31. 173.231 13,520.742 ↓ 2.1 131,299 1

Nested Loop Left Join (cost=670,035.76..1,330,075.40 rows=61,737 width=421) (actual time=8,099.545..13,520.742 rows=131,299 loops=1)

32. 472.403 11,938.506 ↓ 1.8 108,385 1

Hash Left Join (cost=670,035.32..1,274,915.73 rows=61,737 width=413) (actual time=8,099.507..11,938.506 rows=108,385 loops=1)

  • Hash Cond: (t.imei = c.imei)
33. 516.794 11,290.884 ↓ 1.8 108,385 1

Hash Left Join (cost=668,681.67..1,271,246.94 rows=61,737 width=405) (actual time=7,915.822..11,290.884 rows=108,385 loops=1)

  • Hash Cond: (t.cellphone_id = mn.repaired_cellphone_id)
34. 65.153 9,796.458 ↓ 1.8 108,385 1

Hash Left Join (cost=610,883.65..1,199,893.03 rows=61,737 width=401) (actual time=6,929.319..9,796.458 rows=108,385 loops=1)

  • Hash Cond: (t.transaction_status_id = ts.id)
35. 112.083 9,731.247 ↓ 1.8 108,385 1

Hash Left Join (cost=610,878.99..1,199,428.42 rows=61,737 width=376) (actual time=6,929.239..9,731.247 rows=108,385 loops=1)

  • Hash Cond: (t.trocable_id = tr.id)
36. 318.610 9,554.924 ↓ 1.8 108,385 1

Hash Left Join (cost=608,672.92..1,195,866.18 rows=61,737 width=315) (actual time=6,864.961..9,554.924 rows=108,385 loops=1)

  • Hash Cond: (t.id = next_t.transaction_id)
37. 175.103 6,463.836 ↓ 1.8 108,385 1

Nested Loop Left Join (cost=298,845.76..850,112.58 rows=61,737 width=311) (actual time=4,088.901..6,463.836 rows=108,385 loops=1)

38. 91.491 4,888.295 ↓ 2.0 107,726 1

Merge Left Join (cost=298,844.77..536,893.30 rows=53,886 width=200) (actual time=4,088.827..4,888.295 rows=107,726 loops=1)

  • Merge Cond: (t.id = th_fin.transaction_id)
39. 127.681 3,941.710 ↓ 2.0 107,360 1

Nested Loop Left Join (cost=84,324.48..321,012.32 rows=53,886 width=188) (actual time=3,222.512..3,941.710 rows=107,360 loops=1)

40. 102.593 3,384.589 ↓ 2.0 107,360 1

Merge Left Join (cost=84,324.05..84,731.47 rows=53,886 width=148) (actual time=3,222.466..3,384.589 rows=107,360 loops=1)

  • Merge Cond: (t.id = th_por_entrar_return.transaction_id)
41. 217.914 2,198.444 ↓ 2.0 107,293 1

Sort (cost=8,998.02..9,132.73 rows=53,886 width=136) (actual time=2,123.064..2,198.444 rows=107,293 loops=1)

  • Sort Key: t.id
  • Sort Method: external merge Disk: 12784kB
42. 1,980.530 1,980.530 ↓ 2.0 107,293 1

CTE Scan on sell_transactions_with_cellphone t (cost=0.00..1,077.72 rows=53,886 width=136) (actual time=756.269..1,980.530 rows=107,293 loops=1)

43. 157.829 1,083.552 ↓ 3.8 101,991 1

Sort (cost=75,326.03..75,392.36 rows=26,535 width=20) (actual time=1,054.685..1,083.552 rows=101,991 loops=1)

  • Sort Key: th_por_entrar_return.transaction_id
  • Sort Method: external sort Disk: 3792kB
44. 781.368 925.723 ↓ 3.8 101,991 1

Bitmap Heap Scan on transaction_histories th_por_entrar_return (cost=602.08..73,376.29 rows=26,535 width=20) (actual time=149.944..925.723 rows=101,991 loops=1)

  • Recheck Cond: (transaction_status_id = 35)
  • Rows Removed by Index Recheck: 3192395
  • Heap Blocks: exact=29038 lossy=26955
45. 144.355 144.355 ↓ 3.8 102,014 1

Bitmap Index Scan on transaction_histories_transaction_status_id_index (cost=0.00..595.45 rows=26,535 width=0) (actual time=144.355..144.355 rows=102,014 loops=1)

  • Index Cond: (transaction_status_id = 35)
46. 429.440 429.440 ↑ 1.0 1 107,360

Index Scan using persons_pkey on persons p (cost=0.43..4.37 rows=1 width=56) (actual time=0.004..0.004 rows=1 loops=107,360)

  • Index Cond: (t.person_id = id)
  • Filter: (deleted_at IS NULL)
47. 36.899 855.094 ↑ 1.7 91,201 1

Materialize (cost=214,520.29..215,316.33 rows=159,207 width=20) (actual time=789.325..855.094 rows=91,201 loops=1)

48. 118.888 818.195 ↑ 1.7 91,146 1

Sort (cost=214,520.29..214,918.31 rows=159,207 width=20) (actual time=789.320..818.195 rows=91,146 loops=1)

  • Sort Key: th_fin.transaction_id
  • Sort Method: external merge Disk: 3024kB
49. 680.608 699.307 ↑ 1.7 91,146 1

Bitmap Heap Scan on transaction_histories th_fin (cost=3,600.49..197,498.87 rows=159,207 width=20) (actual time=23.492..699.307 rows=91,146 loops=1)

  • Recheck Cond: (transaction_status_id = ANY ('{59,52,51,39,38,37}'::bigint[]))
  • Rows Removed by Index Recheck: 3176027
  • Heap Blocks: exact=25687 lossy=26958
50. 18.699 18.699 ↑ 1.7 91,158 1

Bitmap Index Scan on transaction_histories_transaction_status_id_index (cost=0.00..3,560.69 rows=159,207 width=0) (actual time=18.699..18.699 rows=91,158 loops=1)

  • Index Cond: (transaction_status_id = ANY ('{59,52,51,39,38,37}'::bigint[]))
51. 214.793 1,400.438 ↑ 1.0 1 107,726

Nested Loop Left Join (cost=0.99..5.80 rows=1 width=115) (actual time=0.009..0.013 rows=1 loops=107,726)

52. 104.786 1,077.260 ↑ 1.0 1 107,726

Nested Loop Left Join (cost=0.86..5.64 rows=1 width=100) (actual time=0.007..0.010 rows=1 loops=107,726)

53. 430.904 430.904 ↑ 1.0 1 107,726

Index Scan using deliveries_transaction_id_index on deliveries d (cost=0.43..5.04 rows=1 width=92) (actual time=0.003..0.004 rows=1 loops=107,726)

  • Index Cond: (transaction_id = t.id)
  • Filter: ((delivery_type IS NULL) AND (deleted_at IS NULL))
  • Rows Removed by Filter: 0
54. 541.570 541.570 ↑ 1.0 1 108,314

Index Scan using delivery_status_history_delivery_id_index on delivery_status_history dh_em_transito (cost=0.43..0.59 rows=1 width=16) (actual time=0.003..0.005 rows=1 loops=108,314)

  • Index Cond: (delivery_id = d.id)
  • Filter: (delivery_status_id = 3)
  • Rows Removed by Filter: 3
55. 108.385 108.385 ↑ 1.0 1 108,385

Index Scan using delivery_providers_pkey on delivery_providers dp (cost=0.14..0.15 rows=1 width=23) (actual time=0.001..0.001 rows=1 loops=108,385)

  • Index Cond: (d.delivery_provider_id = id)
56. 899.868 2,772.478 ↑ 84.1 55,405 1

Hash (cost=228,807.41..228,807.41 rows=4,660,860 width=12) (actual time=2,772.478..2,772.478 rows=55,405 loops=1)

  • Buckets: 16384 Batches: 64 Memory Usage: 45kB
57. 1,872.610 1,872.610 ↓ 1.0 4,668,621 1

Seq Scan on transactions next_t (cost=0.00..228,807.41 rows=4,660,860 width=12) (actual time=0.006..1,872.610 rows=4,668,621 loops=1)

  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 11335
58. 15.073 64.240 ↑ 1.0 31,282 1

Hash (cost=1,814.93..1,814.93 rows=31,291 width=77) (actual time=64.240..64.240 rows=31,282 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 3265kB
59. 16.028 49.167 ↑ 1.0 31,282 1

Hash Left Join (cost=232.55..1,814.93 rows=31,291 width=77) (actual time=4.320..49.167 rows=31,282 loops=1)

  • Hash Cond: (tr.cellphone_condition_id = cc.id)
60. 17.622 33.122 ↑ 1.0 31,282 1

Hash Left Join (cost=231.18..1,401.72 rows=31,291 width=71) (actual time=4.285..33.122 rows=31,282 loops=1)

  • Hash Cond: (tr.product_id = pr.id)
61. 11.250 11.250 ↑ 1.0 31,282 1

Seq Scan on trocables tr (cost=0.00..726.53 rows=31,291 width=24) (actual time=0.017..11.250 rows=31,282 loops=1)

  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 1771
62. 0.898 4.250 ↓ 1.0 2,012 1

Hash (cost=206.81..206.81 rows=1,950 width=63) (actual time=4.250..4.250 rows=2,012 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 189kB
63. 1.226 3.352 ↓ 1.0 2,012 1

Hash Left Join (cost=113.20..206.81 rows=1,950 width=63) (actual time=1.426..3.352 rows=2,012 loops=1)

  • Hash Cond: (pr.model_id = m.id)
64. 0.726 0.726 ↓ 1.0 2,012 1

Seq Scan on products pr (cost=0.00..68.60 rows=1,950 width=47) (actual time=0.006..0.726 rows=2,012 loops=1)

  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 110
65. 0.394 1.400 ↓ 1.0 938 1

Hash (cost=101.61..101.61 rows=927 width=32) (actual time=1.400..1.400 rows=938 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 62kB
66. 0.494 1.006 ↓ 1.0 938 1

Hash Left Join (cost=4.65..101.61 rows=927 width=32) (actual time=0.057..1.006 rows=938 loops=1)

  • Hash Cond: (m.brand_id = b.id)
67. 0.484 0.484 ↓ 1.0 938 1

Seq Scan on models m (cost=0.00..84.21 rows=927 width=33) (actual time=0.005..0.484 rows=938 loops=1)

  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 94
68. 0.012 0.028 ↓ 1.0 30 1

Hash (cost=4.29..4.29 rows=29 width=15) (actual time=0.028..0.028 rows=30 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 2kB
69. 0.016 0.016 ↓ 1.0 30 1

Seq Scan on brands b (cost=0.00..4.29 rows=29 width=15) (actual time=0.004..0.016 rows=30 loops=1)

70. 0.009 0.017 ↑ 1.0 16 1

Hash (cost=1.17..1.17 rows=16 width=22) (actual time=0.017..0.017 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
71. 0.008 0.008 ↑ 1.0 16 1

Seq Scan on cellphone_conditions cc (cost=0.00..1.17 rows=16 width=22) (actual time=0.004..0.008 rows=16 loops=1)

  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 1
72. 0.030 0.058 ↑ 1.0 74 1

Hash (cost=3.74..3.74 rows=74 width=29) (actual time=0.058..0.058 rows=74 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 5kB
73. 0.028 0.028 ↑ 1.0 74 1

Seq Scan on transaction_statuses ts (cost=0.00..3.74 rows=74 width=29) (actual time=0.004..0.028 rows=74 loops=1)

  • Filter: (deleted_at IS NULL)
74. 397.478 977.632 ↑ 1.5 818,480 1

Hash (cost=36,560.62..36,560.62 rows=1,221,712 width=16) (actual time=977.632..977.632 rows=818,480 loops=1)

  • Buckets: 16384 Batches: 16 Memory Usage: 2219kB
75. 580.154 580.154 ↓ 1.0 1,227,684 1

Seq Scan on maintenances mn (cost=0.00..36,560.62 rows=1,221,712 width=16) (actual time=0.011..580.154 rows=1,227,684 loops=1)

  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 178713
76. 39.961 175.219 ↓ 514.2 102,835 1

Hash (cost=1,351.15..1,351.15 rows=200 width=40) (actual time=175.219..175.219 rows=102,835 loops=1)

  • Buckets: 1024 Batches: 2 (originally 1) Memory Usage: 4097kB
77. 103.613 135.258 ↓ 514.2 102,835 1

HashAggregate (cost=1,347.15..1,349.15 rows=200 width=32) (actual time=96.418..135.258 rows=102,835 loops=1)

  • Group Key: c.imei
78. 31.645 31.645 ↓ 2.0 107,293 1

CTE Scan on sell_transactions_with_cellphone c (cost=0.00..1,077.72 rows=53,886 width=32) (actual time=0.039..31.645 rows=107,293 loops=1)

79. 1,409.005 1,409.005 ↑ 1.0 1 108,385

Index Scan using maintenance_histories_maintenance_id_index on maintenance_histories mh_repair (cost=0.43..0.88 rows=1 width=12) (actual time=0.012..0.013 rows=1 loops=108,385)

  • Index Cond: (mn.id = maintenance_id)
  • Filter: (maintenance_status = 3)
  • Rows Removed by Filter: 6
80. 787.794 787.794 ↓ 0.0 0 131,299

Index Scan using maintenance_histories_maintenance_id_index on maintenance_histories mh_external_repair (cost=0.43..0.88 rows=1 width=12) (actual time=0.005..0.006 rows=0 loops=131,299)

  • Index Cond: (mn.id = maintenance_id)
  • Filter: (maintenance_status = 10)
  • Rows Removed by Filter: 8
81. 804.870 804.870 ↑ 1.0 1 134,145

Index Scan using revisions_declared_phone_id_index on revisions r (cost=0.43..0.53 rows=1 width=34) (actual time=0.005..0.006 rows=1 loops=134,145)

  • Index Cond: (declared_phone_id = mn.original_cellphone_id)
  • Filter: ((deleted_at IS NULL) AND (revision_status_id <> 8))
82. 0.009 0.018 ↑ 1.0 13 1

Hash (cost=1.23..1.23 rows=13 width=16) (actual time=0.018..0.018 rows=13 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
83. 0.009 0.009 ↑ 1.0 13 1

Seq Scan on external_repairers er (cost=0.00..1.23 rows=13 width=16) (actual time=0.006..0.009 rows=13 loops=1)

  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 10
84. 0.016 0.067 ↑ 1.6 45 1

Hash (cost=5.45..5.45 rows=73 width=16) (actual time=0.067..0.067 rows=45 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
85. 0.051 0.051 ↑ 1.6 45 1

Seq Scan on reviewers rw1 (cost=0.00..5.45 rows=73 width=16) (actual time=0.009..0.051 rows=45 loops=1)

  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 203
86. 0.018 0.053 ↑ 1.6 45 1

Hash (cost=5.45..5.45 rows=73 width=16) (actual time=0.053..0.053 rows=45 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 3kB
87. 0.035 0.035 ↑ 1.6 45 1

Seq Scan on reviewers rw2 (cost=0.00..5.45 rows=73 width=16) (actual time=0.004..0.035 rows=45 loops=1)

  • Filter: (deleted_at IS NULL)
  • Rows Removed by Filter: 203
88. 1,603.427 1,603.427 ↑ 1.0 1 229,061

Index Scan using quality_assurance_pkey on quality_assurance qa (cost=0.42..0.49 rows=1 width=33) (actual time=0.006..0.007 rows=1 loops=229,061)

  • Index Cond: (r.quality_assurance_id = id)
Planning time : 14.395 ms
Execution time : 41,018.157 ms