explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3dNV : work_mem_512

Settings
# exclusive inclusive rows x rows loops node
1. 5.676 12,467.894 ↑ 1.0 1 1

Aggregate (cost=299,814.18..299,814.19 rows=1 width=8) (actual time=12,467.894..12,467.894 rows=1 loops=1)

2.          

CTE mvsm_stacks

3. 0.156 0.156 ↑ 1.0 21 1

Seq Scan on unified_stacks (cost=0.00..64.61 rows=21 width=8) (actual time=0.014..0.156 rows=21 loops=1)

  • Filter: (vehicle_type_pk IS NOT NULL)
  • Rows Removed by Filter: 4140
4. 17.091 12,462.218 ↓ 4,201.7 88,235 1

Hash Right Join (cost=290,882.03..299,749.51 rows=21 width=0) (actual time=12,425.283..12,462.218 rows=88,235 loops=1)

  • Hash Cond: (s.trip_pk = t.pk)
  • Join Filter: ((bp.start_stamp <= t.billing_end) AND (bp.end_stamp >= t.billing_end))
  • Rows Removed by Join Filter: 5381
5. 104.007 460.611 ↑ 4.6 81,733 1

HashAggregate (cost=39,876.43..43,610.07 rows=373,364 width=44) (actual time=437.138..460.611 rows=81,733 loops=1)

  • Group Key: s.trip_pk, bp.start_stamp, bp.end_stamp
6. 74.495 356.604 ↓ 1.1 406,026 1

Hash Join (cost=6.35..37,076.20 rows=373,364 width=12) (actual time=0.112..356.604 rows=406,026 loops=1)

  • Hash Cond: (s.billing_period_pk = bp.pk)
7. 108.965 282.064 ↓ 1.1 406,026 1

Hash Join (cost=1.11..31,937.21 rows=373,364 width=8) (actual time=0.052..282.064 rows=406,026 loops=1)

  • Hash Cond: (s.sale_type_pk = st.pk)
8. 173.085 173.085 ↑ 1.0 463,749 1

Seq Scan on sales s (cost=0.00..26,452.31 rows=466,705 width=12) (actual time=0.016..173.085 rows=463,749 loops=1)

  • Filter: (trip_cost_pk IS NULL)
  • Rows Removed by Filter: 702658
9. 0.003 0.014 ↑ 1.0 4 1

Hash (cost=1.06..1.06 rows=4 width=4) (actual time=0.014..0.014 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
10. 0.011 0.011 ↑ 1.0 4 1

Seq Scan on sale_types st (cost=0.00..1.06 rows=4 width=4) (actual time=0.009..0.011 rows=4 loops=1)

  • Filter: ((name)::text <> 'driving_credit'::text)
  • Rows Removed by Filter: 1
11. 0.017 0.045 ↑ 1.0 144 1

Hash (cost=3.44..3.44 rows=144 width=12) (actual time=0.045..0.045 rows=144 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
12. 0.028 0.028 ↑ 1.0 144 1

Seq Scan on billing_periods bp (cost=0.00..3.44 rows=144 width=12) (actual time=0.004..0.028 rows=144 loops=1)

13. 12.472 11,984.516 ↓ 4,201.7 88,235 1

Hash (cost=251,005.34..251,005.34 rows=21 width=8) (actual time=11,984.516..11,984.516 rows=88,235 loops=1)

  • Buckets: 131072 (originally 1024) Batches: 1 (originally 1) Memory Usage: 4471kB
14. 20.216 11,972.044 ↓ 4,201.7 88,235 1

Hash Right Join (cost=242,137.87..251,005.34 rows=21 width=8) (actual time=11,931.062..11,972.044 rows=88,235 loops=1)

  • Hash Cond: (s_1.trip_pk = t.pk)
  • Join Filter: (bp_1.start_stamp > t.billing_end)
  • Rows Removed by Join Filter: 5
15. 109.268 488.654 ↑ 4.6 81,733 1

HashAggregate (cost=39,876.43..43,610.07 rows=373,364 width=44) (actual time=464.957..488.654 rows=81,733 loops=1)

  • Group Key: s_1.trip_pk, bp_1.start_stamp, bp_1.end_stamp
16. 78.100 379.386 ↓ 1.1 406,026 1

Hash Join (cost=6.35..37,076.20 rows=373,364 width=12) (actual time=0.144..379.386 rows=406,026 loops=1)

  • Hash Cond: (s_1.billing_period_pk = bp_1.pk)
17. 115.135 301.232 ↓ 1.1 406,026 1

Hash Join (cost=1.11..31,937.21 rows=373,364 width=8) (actual time=0.079..301.232 rows=406,026 loops=1)

  • Hash Cond: (s_1.sale_type_pk = st_1.pk)
18. 186.068 186.068 ↑ 1.0 463,749 1

Seq Scan on sales s_1 (cost=0.00..26,452.31 rows=466,705 width=12) (actual time=0.027..186.068 rows=463,749 loops=1)

  • Filter: (trip_cost_pk IS NULL)
  • Rows Removed by Filter: 702658
19. 0.006 0.029 ↑ 1.0 4 1

Hash (cost=1.06..1.06 rows=4 width=4) (actual time=0.029..0.029 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
20. 0.023 0.023 ↑ 1.0 4 1

Seq Scan on sale_types st_1 (cost=0.00..1.06 rows=4 width=4) (actual time=0.022..0.023 rows=4 loops=1)

  • Filter: ((name)::text <> 'driving_credit'::text)
  • Rows Removed by Filter: 1
21. 0.023 0.054 ↑ 1.0 144 1

Hash (cost=3.44..3.44 rows=144 width=12) (actual time=0.054..0.054 rows=144 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
22. 0.031 0.031 ↑ 1.0 144 1

Seq Scan on billing_periods bp_1 (cost=0.00..3.44 rows=144 width=12) (actual time=0.005..0.031 rows=144 loops=1)

23. 18.961 11,463.174 ↓ 4,201.7 88,235 1

Hash (cost=202,261.17..202,261.17 rows=21 width=8) (actual time=11,463.174..11,463.174 rows=88,235 loops=1)

  • Buckets: 131072 (originally 1024) Batches: 1 (originally 1) Memory Usage: 4471kB
24. 24.687 11,444.213 ↓ 4,201.7 88,235 1

Hash Semi Join (cost=193,307.58..202,261.17 rows=21 width=8) (actual time=3,720.686..11,444.213 rows=88,235 loops=1)

  • Hash Cond: (t.pk = t_1.pk)
25. 439.652 11,249.030 ↓ 11.5 110,754 1

Hash Right Join (cost=163,852.48..172,780.64 rows=9,596 width=8) (actual time=3,549.768..11,249.030 rows=110,754 loops=1)

  • Hash Cond: (tc.trip_pk = t.pk)
26. 978.591 10,326.689 ↑ 1.4 1,405,492 1

Nested Loop (cost=120,935.69..122,624.76 rows=1,904,836 width=4) (actual time=3,063.921..10,326.689 rows=1,405,492 loops=1)

27. 1,492.631 3,726.130 ↓ 7,027.5 1,405,492 1

HashAggregate (cost=120,935.26..120,937.26 rows=200 width=4) (actual time=3,063.832..3,726.130 rows=1,405,492 loops=1)

  • Group Key: max(tc_1.pk)
28. 1,372.760 2,233.499 ↓ 3.2 1,405,492 1

HashAggregate (cost=111,064.40..115,451.45 rows=438,705 width=8) (actual time=1,634.428..2,233.499 rows=1,405,492 loops=1)

  • Group Key: tc_1.trip_pk
29. 860.739 860.739 ↓ 2.6 1,405,563 1

Seq Scan on trip_costs tc_1 (cost=0.00..108,365.26 rows=539,827 width=8) (actual time=0.031..860.739 rows=1,405,563 loops=1)

  • Filter: ((is_estimate = 'N'::bpchar) AND (is_current = 'Y'::bpchar) AND (is_selected = 'Y'::bpchar))
  • Rows Removed by Filter: 2403307
30. 5,621.968 5,621.968 ↑ 1.0 1 1,405,492

Index Scan using trip_costs_pkey on trip_costs tc (cost=0.43..8.43 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=1,405,492)

  • Index Cond: (pk = (max(tc_1.pk)))
31. 16.446 482.689 ↓ 15.6 110,754 1

Hash (cost=42,828.08..42,828.08 rows=7,097 width=8) (actual time=482.689..482.689 rows=110,754 loops=1)

  • Buckets: 131072 (originally 8192) Batches: 1 (originally 1) Memory Usage: 5351kB
32. 22.358 466.243 ↓ 15.6 110,754 1

Hash Left Join (cost=42,364.55..42,828.08 rows=7,097 width=8) (actual time=395.866..466.243 rows=110,754 loops=1)

  • Hash Cond: (t_usr.status_pk = t_usrs.pk)
  • Filter: ((t_usr.stack_pk IS NULL) OR (t_usrs.pk IS NOT NULL))
  • Rows Removed by Filter: 30
33. 56.484 443.872 ↓ 15.6 110,784 1

Hash Right Join (cost=42,363.52..42,764.95 rows=7,097 width=16) (actual time=395.837..443.872 rows=110,784 loops=1)

  • Hash Cond: (t_usr.stack_pk = t_us.pk)
  • Join Filter: ((t.billing_end > t_usr.start_stamp) AND (t.billing_end <= t_usr.end_stamp))
  • Rows Removed by Join Filter: 441677
34. 0.678 0.678 ↑ 1.0 8,191 1

Seq Scan on unified_stack_resources t_usr (cost=0.00..150.91 rows=8,191 width=20) (actual time=0.009..0.678 rows=8,191 loops=1)

35. 2.459 386.710 ↓ 2.2 15,453 1

Hash (cost=42,274.80..42,274.80 rows=7,097 width=12) (actual time=386.710..386.710 rows=15,453 loops=1)

  • Buckets: 16384 (originally 8192) Batches: 1 (originally 1) Memory Usage: 792kB
36. 2.807 384.251 ↓ 2.2 15,453 1

Hash Left Join (cost=41,836.32..42,274.80 rows=7,097 width=12) (actual time=374.015..384.251 rows=15,453 loops=1)

  • Hash Cond: (t.billing_stack_pk = t_us.pk)
37. 6.067 380.312 ↓ 2.2 15,453 1

Hash Right Join (cost=41,719.70..42,060.60 rows=7,097 width=12) (actual time=372.841..380.312 rows=15,453 loops=1)

  • Hash Cond: (r_usr.stack_pk = r_us.pk)
  • Join Filter: ((r.end_stamp > r_usr.start_stamp) AND (r.end_stamp <= r_usr.end_stamp))
  • Rows Removed by Join Filter: 20155
38. 1.083 2.667 ↓ 2.0 8,049 1

Nested Loop (cost=0.28..215.91 rows=4,096 width=12) (actual time=0.034..2.667 rows=8,049 loops=1)

39. 0.011 0.011 ↑ 1.0 1 1

Seq Scan on unified_stack_resource_status r_usrs (cost=0.00..1.02 rows=1 width=4) (actual time=0.010..0.011 rows=1 loops=1)

  • Filter: ((name)::text = 'normal'::text)
  • Rows Removed by Filter: 1
40. 1.573 1.573 ↓ 2.0 8,049 1

Index Scan using idx_unified_stack_resources_status_pk on unified_stack_resources r_usr (cost=0.28..173.93 rows=4,096 width=20) (actual time=0.022..1.573 rows=8,049 loops=1)

  • Index Cond: (status_pk = r_usrs.pk)
41. 3.386 371.578 ↓ 1.6 11,188 1

Hash (cost=41,630.70..41,630.70 rows=7,097 width=20) (actual time=371.578..371.578 rows=11,188 loops=1)

  • Buckets: 16384 (originally 8192) Batches: 1 (originally 1) Memory Usage: 697kB
42. 4.756 368.192 ↓ 1.6 11,188 1

Hash Left Join (cost=6,540.66..41,630.70 rows=7,097 width=20) (actual time=59.598..368.192 rows=11,188 loops=1)

  • Hash Cond: (r.stack_pk = r_us.pk)
43. 3.273 362.439 ↓ 1.6 11,188 1

Hash Join (cost=6,424.04..41,416.50 rows=7,097 width=20) (actual time=58.563..362.439 rows=11,188 loops=1)

  • Hash Cond: (a.rate_plan_pk = a_rp.pk)
44. 10.794 359.034 ↓ 1.6 11,188 1

Nested Loop Left Join (cost=6,405.82..41,300.70 rows=7,097 width=24) (actual time=58.424..359.034 rows=11,188 loops=1)

45. 7.934 225.172 ↓ 1.6 11,188 1

Nested Loop (cost=6,400.08..37,613.39 rows=7,097 width=20) (actual time=58.217..225.172 rows=11,188 loops=1)

46. 2.946 194.862 ↓ 1.6 11,188 1

Hash Join (cost=6,399.67..34,201.46 rows=7,097 width=24) (actual time=58.207..194.862 rows=11,188 loops=1)

  • Hash Cond: (m.member_type_pk = mt.pk)
47. 2.562 191.907 ↓ 1.6 11,188 1

Nested Loop (cost=6,398.58..34,102.79 rows=7,097 width=28) (actual time=58.191..191.907 rows=11,188 loops=1)

48. 1.208 155.781 ↓ 1.6 11,188 1

Nested Loop (cost=6,398.16..29,968.08 rows=7,097 width=20) (actual time=58.175..155.781 rows=11,188 loops=1)

49. 0.183 109.821 ↓ 1.6 11,188 1

Nested Loop (cost=6,397.74..25,160.29 rows=7,097 width=24) (actual time=58.129..109.821 rows=11,188 loops=1)

50. 7.720 76.074 ↓ 1.6 11,188 1

Hash Join (cost=6,397.32..21,791.47 rows=7,097 width=28) (actual time=58.094..76.074 rows=11,188 loops=1)

  • Hash Cond: (t.driver_pk = d.pk)
51. 2.538 12.268 ↓ 1.6 11,188 1

Hash Join (cost=155.04..15,451.61 rows=7,097 width=20) (actual time=1.098..12.268 rows=11,188 loops=1)

  • Hash Cond: (t.status_pk = ts.pk)
52. 8.852 9.720 ↓ 1.6 11,188 1

Bitmap Heap Scan on trips t (cost=153.97..15,352.96 rows=7,097 width=28) (actual time=1.079..9.720 rows=11,188 loops=1)

  • Recheck Cond: ((billing_end >= 1551420000) AND (billing_end <= 1553317199))
  • Filter: ((void = 'N'::bpchar) AND (unconfirmed = 'N'::bpchar))
  • Rows Removed by Filter: 186
  • Heap Blocks: exact=1916
53. 0.868 0.868 ↓ 1.6 11,374 1

Bitmap Index Scan on trips_inx7 (cost=0.00..152.20 rows=7,177 width=0) (actual time=0.868..0.868 rows=11,374 loops=1)

  • Index Cond: ((billing_end >= 1551420000) AND (billing_end <= 1553317199))
54. 0.006 0.010 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=4) (actual time=0.010..0.010 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
55. 0.004 0.004 ↑ 1.0 3 1

Seq Scan on trip_status ts (cost=0.00..1.03 rows=3 width=4) (actual time=0.004..0.004 rows=3 loops=1)

56. 30.545 56.086 ↑ 1.0 156,258 1

Hash (cost=4,288.79..4,288.79 rows=156,279 width=16) (actual time=56.086..56.086 rows=156,258 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 9373kB
57. 25.541 25.541 ↑ 1.0 156,258 1

Seq Scan on drivers d (cost=0.00..4,288.79 rows=156,279 width=16) (actual time=0.008..25.541 rows=156,258 loops=1)

58. 33.564 33.564 ↑ 1.0 1 11,188

Index Only Scan using logins_pk_role_pk on logins l (cost=0.42..0.46 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=11,188)

  • Index Cond: (pk = d.login_pk)
  • Heap Fetches: 1422
59. 44.752 44.752 ↑ 1.0 1 11,188

Index Only Scan using contacts_pkey on contacts dc (cost=0.42..0.67 rows=1 width=4) (actual time=0.004..0.004 rows=1 loops=11,188)

  • Index Cond: (pk = d.contact_pk)
  • Heap Fetches: 1107
60. 33.564 33.564 ↑ 1.0 1 11,188

Index Scan using member_pk_contact_pk on members m (cost=0.42..0.57 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=11,188)

  • Index Cond: (pk = d.member_pk)
61. 0.003 0.009 ↑ 1.0 4 1

Hash (cost=1.04..1.04 rows=4 width=4) (actual time=0.008..0.009 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
62. 0.006 0.006 ↑ 1.0 4 1

Seq Scan on member_types mt (cost=0.00..1.04 rows=4 width=4) (actual time=0.004..0.006 rows=4 loops=1)

63. 22.376 22.376 ↑ 1.0 1 11,188

Index Scan using accounts_member_payment_info_pk on accounts a (cost=0.42..0.47 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=11,188)

  • Index Cond: (member_pk = d.member_pk)
64. 44.752 123.068 ↑ 1.0 1 11,188

Hash Right Join (cost=5.74..6.25 rows=1 width=12) (actual time=0.010..0.011 rows=1 loops=11,188)

  • Hash Cond: (mvsm_stacks.pk = r.stack_pk)
65. 22.376 22.376 ↑ 1.0 21 11,188

CTE Scan on mvsm_stacks (cost=0.00..0.42 rows=21 width=4) (actual time=0.000..0.002 rows=21 loops=11,188)

66. 11.188 55.940 ↑ 1.0 1 11,188

Hash (cost=5.73..5.73 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=11,188)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
67. 44.752 44.752 ↑ 1.0 1 11,188

Index Scan using reservations_pkey on reservations r (cost=0.43..5.73 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=11,188)

  • Index Cond: (t.reservation_pk = pk)
68. 0.060 0.132 ↑ 1.0 454 1

Hash (cost=12.54..12.54 rows=454 width=4) (actual time=0.132..0.132 rows=454 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
69. 0.072 0.072 ↑ 1.0 454 1

Seq Scan on rate_plans a_rp (cost=0.00..12.54 rows=454 width=4) (actual time=0.008..0.072 rows=454 loops=1)

70. 0.562 0.997 ↑ 1.0 4,161 1

Hash (cost=64.61..64.61 rows=4,161 width=12) (actual time=0.997..0.997 rows=4,161 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 243kB
71. 0.435 0.435 ↑ 1.0 4,161 1

Seq Scan on unified_stacks r_us (cost=0.00..64.61 rows=4,161 width=12) (actual time=0.002..0.435 rows=4,161 loops=1)

72. 0.566 1.132 ↑ 1.0 4,161 1

Hash (cost=64.61..64.61 rows=4,161 width=12) (actual time=1.131..1.132 rows=4,161 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 243kB
73. 0.566 0.566 ↑ 1.0 4,161 1

Seq Scan on unified_stacks t_us (cost=0.00..64.61 rows=4,161 width=12) (actual time=0.006..0.566 rows=4,161 loops=1)

74. 0.003 0.013 ↑ 1.0 1 1

Hash (cost=1.02..1.02 rows=1 width=4) (actual time=0.013..0.013 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
75. 0.010 0.010 ↑ 1.0 1 1

Seq Scan on unified_stack_resource_status t_usrs (cost=0.00..1.02 rows=1 width=4) (actual time=0.009..0.010 rows=1 loops=1)

  • Filter: ((name)::text = 'normal'::text)
  • Rows Removed by Filter: 1
76. 0.970 170.496 ↓ 2.9 8,854 1

Hash (cost=29,416.73..29,416.73 rows=3,070 width=4) (actual time=170.496..170.496 rows=8,854 loops=1)

  • Buckets: 16384 (originally 4096) Batches: 1 (originally 1) Memory Usage: 440kB
77. 2.286 169.526 ↓ 2.9 8,854 1

Unique (cost=29,370.68..29,386.03 rows=3,070 width=4) (actual time=165.235..169.526 rows=8,854 loops=1)

78. 7.447 167.240 ↓ 7.4 22,775 1

Sort (cost=29,370.68..29,378.36 rows=3,070 width=4) (actual time=165.235..167.240 rows=22,775 loops=1)

  • Sort Key: t_1.pk
  • Sort Method: quicksort Memory: 1836kB
79. 5.059 159.793 ↓ 7.4 22,775 1

Hash Join (cost=6,996.20..29,192.87 rows=3,070 width=4) (actual time=64.562..159.793 rows=22,775 loops=1)

  • Hash Cond: (us.lot_pk = l_1.pk)
80. 5.130 153.992 ↓ 7.4 22,775 1

Hash Join (cost=6,906.94..29,061.39 rows=3,070 width=8) (actual time=63.790..153.992 rows=22,775 loops=1)

  • Hash Cond: ((us.status_pk = uss.pk) AND (usr.status_pk = usrs.pk))
81. 6.088 148.836 ↓ 1.3 23,070 1

Hash Join (cost=6,904.85..28,890.43 rows=18,423 width=16) (actual time=63.745..148.836 rows=23,070 loops=1)

  • Hash Cond: (usr.stack_pk = us.pk)
82. 5.020 141.250 ↓ 1.3 23,070 1

Hash Join (cost=6,788.23..28,520.50 rows=18,423 width=12) (actual time=62.201..141.250 rows=23,070 loops=1)

  • Hash Cond: (t_1.resource_pk = usr.vehicle_pk)
83. 2.725 133.973 ↓ 1.4 8,854 1

Hash Join (cost=6,534.93..27,920.69 rows=6,182 width=12) (actual time=59.909..133.973 rows=8,854 loops=1)

  • Hash Cond: (t_1.resource_pk = v.pk)
84. 2.690 130.574 ↓ 1.4 8,854 1

Nested Loop (cost=6,416.20..27,716.95 rows=6,182 width=8) (actual time=59.213..130.574 rows=8,854 loops=1)

85. 2.201 110.176 ↓ 1.4 8,854 1

Hash Join (cost=6,415.78..24,781.31 rows=6,182 width=16) (actual time=59.186..110.176 rows=8,854 loops=1)

  • Hash Cond: (a_1.rate_plan_pk = rp.pk)
86. 7.196 107.776 ↓ 1.6 9,704 1

Nested Loop (cost=6,396.44..24,676.91 rows=6,196 width=20) (actual time=58.972..107.776 rows=9,704 loops=1)

87. 5.875 81.172 ↓ 1.6 9,704 1

Hash Join (cost=6,396.02..21,698.15 rows=6,196 width=12) (actual time=58.943..81.172 rows=9,704 loops=1)

  • Hash Cond: (t_1.driver_pk = d_1.pk)
88. 17.501 18.461 ↓ 1.6 9,704 1

Bitmap Heap Scan on trips t_1 (cost=153.75..15,370.67 rows=6,196 width=12) (actual time=1.177..18.461 rows=9,704 loops=1)

  • Recheck Cond: ((billing_end >= 1551420000) AND (billing_end <= 1553317199))
  • Filter: ((void = 'N'::bpchar) AND (unconfirmed = 'N'::bpchar) AND (cancelled = 'N'::bpchar))
  • Rows Removed by Filter: 1670
  • Heap Blocks: exact=1916
89. 0.960 0.960 ↓ 1.6 11,374 1

Bitmap Index Scan on trips_inx7 (cost=0.00..152.20 rows=7,177 width=0) (actual time=0.960..0.960 rows=11,374 loops=1)

  • Index Cond: ((billing_end >= 1551420000) AND (billing_end <= 1553317199))
90. 29.033 56.836 ↑ 1.0 156,258 1

Hash (cost=4,288.79..4,288.79 rows=156,279 width=8) (actual time=56.836..56.836 rows=156,258 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 8152kB
91. 27.803 27.803 ↑ 1.0 156,258 1

Seq Scan on drivers d_1 (cost=0.00..4,288.79 rows=156,279 width=8) (actual time=0.013..27.803 rows=156,258 loops=1)

92. 19.408 19.408 ↑ 1.0 1 9,704

Index Scan using accounts_member_payment_info_pk on accounts a_1 (cost=0.42..0.47 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=9,704)

  • Index Cond: (member_pk = d_1.member_pk)
93. 0.044 0.199 ↑ 1.0 453 1

Hash (cost=13.68..13.68 rows=453 width=4) (actual time=0.199..0.199 rows=453 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 24kB
94. 0.155 0.155 ↑ 1.0 453 1

Seq Scan on rate_plans rp (cost=0.00..13.68 rows=453 width=4) (actual time=0.014..0.155 rows=453 loops=1)

  • Filter: (is_billable_exempt = 'N'::bpchar)
  • Rows Removed by Filter: 1
95. 17.708 17.708 ↑ 1.0 1 8,854

Index Only Scan using member_pk_contact_pk on members m_1 (cost=0.42..0.46 rows=1 width=4) (actual time=0.002..0.002 rows=1 loops=8,854)

  • Index Cond: (pk = d_1.member_pk)
  • Heap Fetches: 507
96. 0.332 0.674 ↓ 1.0 2,855 1

Hash (cost=83.08..83.08 rows=2,853 width=4) (actual time=0.674..0.674 rows=2,855 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 133kB
97. 0.342 0.342 ↓ 1.0 2,855 1

Index Only Scan using vehicles_pkey on vehicles v (cost=0.28..83.08 rows=2,853 width=4) (actual time=0.018..0.342 rows=2,855 loops=1)

  • Heap Fetches: 110
98. 1.108 2.257 ↑ 1.0 8,191 1

Hash (cost=150.91..150.91 rows=8,191 width=12) (actual time=2.257..2.257 rows=8,191 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 416kB
99. 1.149 1.149 ↑ 1.0 8,191 1

Seq Scan on unified_stack_resources usr (cost=0.00..150.91 rows=8,191 width=12) (actual time=0.005..1.149 rows=8,191 loops=1)

100. 0.791 1.498 ↑ 1.0 4,161 1

Hash (cost=64.61..64.61 rows=4,161 width=12) (actual time=1.498..1.498 rows=4,161 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 243kB
101. 0.707 0.707 ↑ 1.0 4,161 1

Seq Scan on unified_stacks us (cost=0.00..64.61 rows=4,161 width=12) (actual time=0.012..0.707 rows=4,161 loops=1)

102. 0.003 0.026 ↑ 1.0 1 1

Hash (cost=2.07..2.07 rows=1 width=8) (actual time=0.026..0.026 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
103. 0.001 0.023 ↑ 1.0 1 1

Nested Loop (cost=0.00..2.07 rows=1 width=8) (actual time=0.021..0.023 rows=1 loops=1)

104. 0.013 0.013 ↑ 1.0 1 1

Seq Scan on unified_stack_status uss (cost=0.00..1.04 rows=1 width=4) (actual time=0.013..0.013 rows=1 loops=1)

  • Filter: ((name)::text = 'normal'::text)
  • Rows Removed by Filter: 2
105. 0.009 0.009 ↑ 1.0 1 1

Seq Scan on unified_stack_resource_status usrs (cost=0.00..1.02 rows=1 width=4) (actual time=0.008..0.009 rows=1 loops=1)

  • Filter: ((name)::text = 'normal'::text)
  • Rows Removed by Filter: 1
106. 0.390 0.742 ↑ 1.0 2,072 1

Hash (cost=63.36..63.36 rows=2,072 width=4) (actual time=0.742..0.742 rows=2,072 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 105kB
107. 0.352 0.352 ↑ 1.0 2,072 1

Index Only Scan using lots_pkey on lots l_1 (cost=0.28..63.36 rows=2,072 width=4) (actual time=0.023..0.352 rows=2,072 loops=1)

  • Heap Fetches: 0
Planning time : 22.500 ms