explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bIKE

Settings
# exclusive inclusive rows x rows loops node
1. 0.028 3,293.944 ↓ 4.4 31 1

GroupAggregate (cost=1,223,216.85..1,223,217.05 rows=7 width=44) (actual time=3,293.913..3,293.944 rows=31 loops=1)

  • Group Key: (width_bucket((date_part('epoch'::text, e1.timestamp_))::numeric, '1561960800'::numeric, 1562047199.999, 20)), (((CASE WHEN (row_number() OVER (?) = 1) THEN 'First'::text ELSE 'Subsequent'::text END))::character varying)
  • Buffers: shared hit=564442
2. 0.176 3,293.916 ↓ 21.1 148 1

Sort (cost=1,223,216.85..1,223,216.87 rows=7 width=52) (actual time=3,293.909..3,293.916 rows=148 loops=1)

  • Sort Key: (width_bucket((date_part('epoch'::text, e1.timestamp_))::numeric, '1561960800'::numeric, 1562047199.999, 20)), (((CASE WHEN (row_number() OVER (?) = 1) THEN 'First'::text ELSE 'Subsequent'::text END))::character varying)
  • Sort Method: quicksort Memory: 36kB
  • Buffers: shared hit=564442
3. 116.255 3,293.740 ↓ 21.1 148 1

Hash Join (cost=1,172,893.22..1,223,216.75 rows=7 width=52) (actual time=2,492.553..3,293.740 rows=148 loops=1)

  • Hash Cond: (ex.id = e1.id)
  • Buffers: shared hit=564436
4. 495.620 3,177.289 ↑ 1.0 1,332,613 1

WindowAgg (cost=1,172,881.31..1,204,116.53 rows=1,388,232 width=80) (actual time=2,486.258..3,177.289 rows=1,332,613 loops=1)

  • Buffers: shared hit=564364
5. 1,011.135 2,681.669 ↑ 1.0 1,332,613 1

Sort (cost=1,172,881.31..1,176,351.89 rows=1,388,232 width=40) (actual time=2,486.248..2,681.669 rows=1,332,613 loops=1)

  • Sort Key: ex.person_id, ex.timestamp_
  • Sort Method: quicksort Memory: 153263kB
  • Buffers: shared hit=564364
6. 134.948 1,670.534 ↑ 1.0 1,332,613 1

Result (cost=0.00..1,031,248.21 rows=1,388,232 width=40) (actual time=0.110..1,670.534 rows=1,332,613 loops=1)

  • Buffers: shared hit=564358
7. 105.532 1,535.586 ↑ 1.0 1,332,613 1

Append (cost=0.00..1,017,365.89 rows=1,388,232 width=40) (actual time=0.110..1,535.586 rows=1,332,613 loops=1)

  • Buffers: shared hit=564358
8. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc ex (cost=0.00..0.00 rows=1 width=40) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
9. 0.003 0.003 ↓ 0.0 0 1

Seq Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2015_11 ex_1 (cost=0.00..1.45 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Rows Removed by Filter: 4
  • Buffers: shared hit=1
10. 0.009 0.009 ↓ 0.0 0 1

Index Scan using et_ace8b421_634f_4060_9118_ffc36db704dc_2016_5_name_ts_pid_ses on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2016_5 ex_2 (cost=0.42..3.64 rows=1 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Buffers: shared hit=3
11. 0.012 0.012 ↓ 0.0 0 1

Index Scan using et_ace8b421_634f_4060_9118_ffc36db704dc_2016_4_name_ts_pid_ses on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2016_4 ex_3 (cost=0.42..3.64 rows=1 width=40) (actual time=0.011..0.012 rows=0 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Buffers: shared hit=3
12. 0.008 0.008 ↓ 0.0 0 1

Index Scan using et_ace8b421_634f_4060_9118_ffc36db704dc_2016_3_name_ts_pid_ses on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2016_3 ex_4 (cost=0.42..3.64 rows=1 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Buffers: shared hit=3
13. 0.008 0.008 ↓ 0.0 0 1

Index Scan using et_ace8b421_634f_4060_9118_ffc36db704dc_2016_2_name_ts_pid_ses on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2016_2 ex_5 (cost=0.42..3.64 rows=1 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Buffers: shared hit=3
14. 0.008 0.008 ↓ 0.0 0 1

Index Scan using et_ace8b421_634f_4060_9118_ffc36db704dc_2016_6_name_ts_pid_ses on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2016_6 ex_6 (cost=0.41..3.64 rows=1 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Buffers: shared hit=3
15. 0.009 0.009 ↓ 0.0 0 1

Index Scan using et_ace8b421_634f_4060_9118_ffc36db704dc_2016_7_name_ts_pid_ses on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2016_7 ex_7 (cost=0.41..3.64 rows=1 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Buffers: shared hit=3
16. 0.010 0.010 ↓ 0.0 0 1

Index Scan using et_ace8b421_634f_4060_9118_ffc36db704dc_2016_8_name_ts_pid_ses on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2016_8 ex_8 (cost=0.41..3.63 rows=1 width=40) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Buffers: shared hit=3
17. 0.007 0.007 ↓ 0.0 0 1

Index Scan using et_ace8b421_634f_4060_9118_ffc36db704dc_2016_9_name_ts_pid_ses on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2016_9 ex_9 (cost=0.41..3.63 rows=1 width=40) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Buffers: shared hit=3
18. 0.008 0.008 ↓ 0.0 0 1

Index Scan using et_ace8b421_634f_4060_9118_ffc36db704dc_2016_10_name_ts_pid_ses on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2016_10 ex_10 (cost=0.41..3.63 rows=1 width=40) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Buffers: shared hit=3
19. 0.007 0.007 ↓ 0.0 0 1

Index Scan using et_ace8b421_634f_4060_9118_ffc36db704dc_2016_11_name_ts_pid_ses on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2016_11 ex_11 (cost=0.41..3.63 rows=1 width=40) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Buffers: shared hit=3
20. 0.009 0.009 ↓ 0.0 0 1

Index Scan using et_ace8b421_634f_4060_9118_ffc36db704dc_2016_12_name_ts_pid_ses on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2016_12 ex_12 (cost=0.42..19.84 rows=11 width=40) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Buffers: shared hit=3
21. 0.014 0.014 ↑ 1.0 6 1

Index Scan using et_ace8b421_634f_4060_9118_ffc36db704dc_2017_1_name_ts_pid_ses on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2017_1 ex_13 (cost=0.42..11.74 rows=6 width=40) (actual time=0.010..0.014 rows=6 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Buffers: shared hit=6
22. 37.604 42.612 ↑ 1.1 39,424 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2017_2 ex_14 (cost=908.74..39,297.51 rows=44,102 width=40) (actual time=7.296..42.612 rows=39,424 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=16318
  • Buffers: shared hit=16733
23. 5.008 5.008 ↑ 1.1 39,424 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2017_2_name_ts_pid_ses (cost=0.00..897.72 rows=44,102 width=0) (actual time=5.008..5.008 rows=39,424 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=415
24. 132.342 150.839 ↑ 1.0 146,563 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2017_3 ex_15 (cost=3,369.43..90,274.58 rows=150,204 width=40) (actual time=26.865..150.839 rows=146,563 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=51039
  • Buffers: shared hit=52570
25. 18.497 18.497 ↑ 1.0 146,563 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2017_3_name_ts_pid_ses (cost=0.00..3,331.88 rows=150,204 width=0) (actual time=18.497..18.497 rows=146,563 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=1531
26. 138.926 154.437 ↑ 1.0 163,467 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2017_4 ex_16 (cost=3,813.32..81,359.99 rows=169,286 width=40) (actual time=22.707..154.437 rows=163,467 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=49043
  • Buffers: shared hit=50750
27. 15.511 15.511 ↑ 1.0 163,467 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2017_4_name_ts_pid_ses (cost=0.00..3,771.00 rows=169,286 width=0) (actual time=15.511..15.511 rows=163,467 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=1707
28. 41.507 46.222 ↑ 1.1 49,263 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2017_5 ex_17 (cost=1,162.52..34,347.88 rows=53,741 width=40) (actual time=6.780..46.222 rows=49,263 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=14390
  • Buffers: shared hit=14906
29. 4.715 4.715 ↑ 1.1 49,263 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2017_5_name_ts_pid_ses (cost=0.00..1,149.08 rows=53,741 width=0) (actual time=4.715..4.715 rows=49,263 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=516
30. 11.547 12.504 ↑ 1.0 10,000 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2017_6 ex_18 (cost=214.90..12,015.49 rows=10,126 width=40) (actual time=1.607..12.504 rows=10,000 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=5402
  • Buffers: shared hit=5509
31. 0.957 0.957 ↑ 1.0 10,000 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2017_6_name_ts_pid_ses (cost=0.00..212.37 rows=10,126 width=0) (actual time=0.957..0.957 rows=10,000 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=107
32. 6.755 7.316 ↑ 1.7 5,950 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2017_7 ex_19 (cost=168.93..9,299.40 rows=10,182 width=40) (actual time=0.891..7.316 rows=5,950 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=3141
  • Buffers: shared hit=3206
33. 0.561 0.561 ↑ 1.7 5,950 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2017_7_name_ts_pid_ses (cost=0.00..166.38 rows=10,182 width=0) (actual time=0.561..0.561 rows=5,950 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=65
34. 3.575 4.031 ↓ 1.0 3,596 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2017_8 ex_20 (cost=77.24..4,341.41 rows=3,512 width=40) (actual time=0.656..4.031 rows=3,596 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=1873
  • Buffers: shared hit=1913
35. 0.456 0.456 ↓ 1.0 3,596 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2017_8_name_ts_pid_ses (cost=0.00..76.36 rows=3,512 width=0) (actual time=0.456..0.456 rows=3,596 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=40
36. 2.408 2.652 ↓ 1.0 2,252 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2017_9 ex_21 (cost=59.22..2,227.59 rows=2,220 width=40) (actual time=0.381..2.652 rows=2,252 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=1254
  • Buffers: shared hit=1285
37. 0.244 0.244 ↓ 1.0 2,252 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2017_9_name_ts_pid_ses (cost=0.00..58.66 rows=2,220 width=0) (actual time=0.244..0.244 rows=2,252 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=31
38. 1.918 2.195 ↑ 1.0 1,986 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2017_10 ex_22 (cost=70.31..1,845.73 rows=1,999 width=40) (actual time=0.380..2.195 rows=1,986 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=999
  • Buffers: shared hit=1040
39. 0.277 0.277 ↑ 1.0 1,986 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2017_10_name_ts_pid_ses (cost=0.00..69.81 rows=1,999 width=0) (actual time=0.277..0.277 rows=1,986 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=41
40. 1.549 1.722 ↑ 1.0 1,613 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2017_11 ex_23 (cost=54.86..1,566.30 rows=1,657 width=40) (actual time=0.252..1.722 rows=1,613 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=827
  • Buffers: shared hit=861
41. 0.173 0.173 ↑ 1.0 1,613 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2017_11_name_ts_pid_ses (cost=0.00..54.44 rows=1,657 width=0) (actual time=0.173..0.173 rows=1,613 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=34
42. 1.567 1.810 ↓ 1.0 1,333 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2017_12 ex_24 (cost=41.26..2,067.36 rows=1,330 width=40) (actual time=0.357..1.810 rows=1,333 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=1029
  • Buffers: shared hit=1059
43. 0.243 0.243 ↓ 1.0 1,333 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2017_12_name_ts_pid_ses (cost=0.00..40.93 rows=1,330 width=0) (actual time=0.243..0.243 rows=1,333 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=30
44. 2.168 2.450 ↑ 1.0 1,976 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2018_1 ex_25 (cost=59.44..2,816.00 rows=2,041 width=40) (actual time=0.427..2.450 rows=1,976 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=1398
  • Buffers: shared hit=1440
45. 0.282 0.282 ↑ 1.0 1,976 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2018_1_name_ts_pid_ses (cost=0.00..58.93 rows=2,041 width=0) (actual time=0.282..0.282 rows=1,976 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=42
46. 35.088 40.132 ↑ 1.1 34,274 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2018_2 ex_26 (cost=1,214.49..42,041.07 rows=38,340 width=40) (actual time=7.289..40.132 rows=34,274 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=15988
  • Buffers: shared hit=16655
47. 5.044 5.044 ↑ 1.1 34,274 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2018_2_name_ts_pid_ses (cost=0.00..1,204.90 rows=38,340 width=0) (actual time=5.044..5.044 rows=34,274 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=667
48. 168.070 191.376 ↑ 1.0 162,130 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2018_3 ex_27 (cost=5,757.21..128,920.72 rows=163,697 width=40) (actual time=34.986..191.376 rows=162,130 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=72608
  • Buffers: shared hit=75778
49. 23.306 23.306 ↑ 1.0 162,130 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2018_3_name_ts_pid_ses (cost=0.00..5,716.28 rows=163,697 width=0) (actual time=23.306..23.306 rows=162,130 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=3170
50. 187.902 213.761 ↑ 1.1 195,458 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2018_4 ex_28 (cost=7,196.59..135,352.81 rows=210,689 width=40) (actual time=38.436..213.761 rows=195,458 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=77417
  • Buffers: shared hit=81237
51. 25.859 25.859 ↑ 1.1 195,458 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2018_4_name_ts_pid_ses (cost=0.00..7,143.92 rows=210,689 width=0) (actual time=25.859..25.859 rows=195,458 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=3820
52. 28.231 32.150 ↓ 1.0 32,335 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2018_5 ex_29 (cost=1,118.06..27,361.01 rows=31,885 width=40) (actual time=5.433..32.150 rows=32,335 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=11913
  • Buffers: shared hit=12546
53. 3.919 3.919 ↓ 1.0 32,335 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2018_5_name_ts_pid_ses (cost=0.00..1,110.09 rows=31,885 width=0) (actual time=3.919..3.919 rows=32,335 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=633
54. 7.734 8.569 ↑ 1.0 7,388 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2018_6 ex_30 (cost=249.88..8,036.64 rows=7,414 width=40) (actual time=1.331..8.569 rows=7,388 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=4109
  • Buffers: shared hit=4256
55. 0.835 0.835 ↑ 1.0 7,388 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2018_6_name_ts_pid_ses (cost=0.00..248.03 rows=7,414 width=0) (actual time=0.835..0.835 rows=7,388 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=147
56. 5.786 6.388 ↓ 1.0 5,832 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2018_7 ex_31 (cost=205.34..5,495.73 rows=5,796 width=40) (actual time=0.938..6.388 rows=5,832 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=2941
  • Buffers: shared hit=3058
57. 0.602 0.602 ↓ 1.0 5,832 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2018_7_name_ts_pid_ses (cost=0.00..203.89 rows=5,796 width=0) (actual time=0.602..0.602 rows=5,832 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=117
58. 3.236 3.580 ↓ 1.0 3,253 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2018_8 ex_32 (cost=116.67..3,012.41 rows=3,233 width=40) (actual time=0.521..3.580 rows=3,253 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=1653
  • Buffers: shared hit=1720
59. 0.344 0.344 ↓ 1.0 3,253 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2018_8_name_ts_pid_ses (cost=0.00..115.86 rows=3,233 width=0) (actual time=0.344..0.344 rows=3,253 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=67
60. 2.269 2.543 ↑ 1.0 2,010 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2018_9 ex_33 (cost=69.03..2,790.55 rows=2,040 width=40) (actual time=0.402..2.543 rows=2,010 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=1220
  • Buffers: shared hit=1262
61. 0.274 0.274 ↑ 1.0 2,010 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2018_9_name_ts_pid_ses (cost=0.00..68.52 rows=2,040 width=0) (actual time=0.274..0.274 rows=2,010 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=42
62. 1.915 2.177 ↑ 1.0 1,974 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2018_10 ex_34 (cost=70.46..2,003.74 rows=2,019 width=40) (actual time=0.376..2.177 rows=1,974 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=1054
  • Buffers: shared hit=1095
63. 0.262 0.262 ↑ 1.0 1,974 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2018_10_name_ts_pid_ses (cost=0.00..69.96 rows=2,019 width=0) (actual time=0.262..0.262 rows=1,974 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=41
64. 1.527 1.700 ↑ 1.0 1,625 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2018_11 ex_35 (cost=58.07..1,616.59 rows=1,659 width=40) (actual time=0.257..1.700 rows=1,625 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=873
  • Buffers: shared hit=908
65. 0.173 0.173 ↑ 1.0 1,625 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2018_11_name_ts_pid_ses (cost=0.00..57.66 rows=1,659 width=0) (actual time=0.173..0.173 rows=1,625 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=35
66. 1.293 1.466 ↑ 1.0 1,503 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2018_12 ex_36 (cost=52.06..1,440.30 rows=1,503 width=40) (actual time=0.246..1.466 rows=1,503 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=730
  • Buffers: shared hit=762
67. 0.173 0.173 ↑ 1.0 1,503 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2018_12_name_ts_pid_ses (cost=0.00..51.69 rows=1,503 width=0) (actual time=0.173..0.173 rows=1,503 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=32
68. 1.403 1.600 ↓ 1.1 1,426 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2019_1 ex_37 (cost=49.33..1,901.03 rows=1,356 width=40) (actual time=0.280..1.600 rows=1,426 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=839
  • Buffers: shared hit=870
69. 0.197 0.197 ↓ 1.1 1,426 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2019_1_name_ts_pid_ses (cost=0.00..48.99 rows=1,356 width=0) (actual time=0.197..0.197 rows=1,426 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=31
70. 51.651 59.199 ↑ 1.1 53,799 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2019_2 ex_38 (cost=1,958.94..54,451.09 rows=59,457 width=40) (actual time=11.219..59.199 rows=53,799 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=26283
  • Buffers: shared hit=27341
71. 7.548 7.548 ↑ 1.1 53,799 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2019_2_name_ts_pid_ses (cost=0.00..1,944.08 rows=59,457 width=0) (actual time=7.548..7.548 rows=53,799 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=1058
72. 162.019 186.926 ↑ 1.1 172,250 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2019_3 ex_39 (cost=6,417.31..138,368.46 rows=181,568 width=40) (actual time=37.097..186.926 rows=172,250 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=75271
  • Buffers: shared hit=78652
73. 24.907 24.907 ↑ 1.1 172,250 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2019_3_name_ts_pid_ses (cost=0.00..6,371.92 rows=181,568 width=0) (actual time=24.907..24.907 rows=172,250 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=3381
74. 184.518 210.520 ↓ 1.0 192,098 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2019_4 ex_40 (cost=7,324.12..148,629.47 rows=190,395 width=40) (actual time=39.965..210.520 rows=192,098 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=85531
  • Buffers: shared hit=89297
75. 26.002 26.002 ↓ 1.0 192,098 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2019_4_name_ts_pid_ses (cost=0.00..7,276.52 rows=190,395 width=0) (actual time=26.002..26.002 rows=192,098 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=3766
76. 26.215 29.977 ↓ 1.0 29,273 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2019_5 ex_41 (cost=1,034.35..26,671.68 rows=28,310 width=40) (actual time=5.379..29.977 rows=29,273 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=12567
  • Buffers: shared hit=13143
77. 3.762 3.762 ↓ 1.0 29,273 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2019_5_name_ts_pid_ses (cost=0.00..1,027.28 rows=28,310 width=0) (actual time=3.762..3.762 rows=29,273 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=576
78. 6.280 7.099 ↓ 1.0 6,684 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2019_6 ex_42 (cost=249.64..5,990.64 rows=6,558 width=40) (actual time=1.166..7.099 rows=6,684 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=3327
  • Buffers: shared hit=3461
79. 0.819 0.819 ↓ 1.0 6,684 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2019_6_name_ts_pid_ses (cost=0.00..248.00 rows=6,558 width=0) (actual time=0.819..0.819 rows=6,684 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=134
80. 1.699 1.989 ↑ 1.0 1,872 1

Bitmap Heap Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2019_7 ex_43 (cost=72.62..1,753.31 rows=1,884 width=40) (actual time=0.393..1.989 rows=1,872 loops=1)

  • Filter: ((event_name)::text ~~ 'Filed Return'::text)
  • Heap Blocks: exact=966
  • Buffers: shared hit=1005
81. 0.290 0.290 ↑ 1.0 1,872 1

Bitmap Index Scan on et_ace8b421_634f_4060_9118_ffc36db704dc_2019_7_name_ts_pid_ses (cost=0.00..72.15 rows=1,884 width=0) (actual time=0.290..0.290 rows=1,872 loops=1)

  • Index Cond: ((event_name)::text = 'Filed Return'::text)
  • Buffers: shared hit=39
82. 0.029 0.196 ↓ 21.1 148 1

Hash (cost=11.83..11.83 rows=7 width=24) (actual time=0.196..0.196 rows=148 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
  • Buffers: shared hit=72
83. 0.012 0.167 ↓ 21.1 148 1

Append (cost=0.00..11.83 rows=7 width=24) (actual time=0.037..0.167 rows=148 loops=1)

  • Buffers: shared hit=72
84. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on event_track_ace8b421_634f_4060_9118_ffc36db704dc e1 (cost=0.00..0.00 rows=1 width=24) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((timestamp_ >= '2019-07-01 06:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-07-02 05:59:59.999'::timestamp without time zone) AND ((event_name)::text ~~ 'Filed Return'::text) AND (timestamp_ >= '2019-07-01 06:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-07-02 05:59:59.999'::timestamp without time zone) AND ((event_name)::text ~~ 'Filed Return'::text))
85. 0.154 0.154 ↓ 24.7 148 1

Index Scan using et_ace8b421_634f_4060_9118_ffc36db704dc_2019_7_name_ts_pid_ses on event_track_ace8b421_634f_4060_9118_ffc36db704dc_2019_7 e1_1 (cost=0.41..11.83 rows=6 width=24) (actual time=0.036..0.154 rows=148 loops=1)

  • Index Cond: (((event_name)::text = 'Filed Return'::text) AND ((event_name)::text = 'Filed Return'::text) AND (timestamp_ >= '2019-07-01 06:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-07-02 05:59:59.999'::timestamp without time zone) AND (timestamp_ >= '2019-07-01 06:00:00'::timestamp without time zone) AND (timestamp_ <= '2019-07-02 05:59:59.999'::timestamp without time zone))
  • Filter: (((event_name)::text ~~ 'Filed Return'::text) AND ((event_name)::text ~~ 'Filed Return'::text))
  • Buffers: shared hit=72
Planning time : 6.400 ms
Execution time : 3,304.514 ms