explain.depesz.com

PostgreSQL's explain analyze made readable

Result: R2J3V

Settings
# exclusive inclusive rows x rows loops node
1. 0.019 0.536 ↑ 182.0 1 1

Append (cost=0.00..631.80 rows=182 width=103) (actual time=0.526..0.536 rows=1 loops=1)

  • Buffers: shared hit=90 read=1 dirtied=1
2. 0.002 0.002 ↓ 0.0 0 1

Seq Scan on session_play (cost=0.00..0.00 rows=1 width=119) (actual time=0.002..0.002 rows=0 loops=1)

  • Filter: ((date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone) AND (date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)))
3. 0.007 0.028 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2014_04 (cost=4.18..11.31 rows=3 width=119) (actual time=0.028..0.028 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
4. 0.021 0.021 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2014_04_last_update_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.021..0.021 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
5. 0.002 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2014_05 (cost=4.18..11.31 rows=3 width=119) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
6. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2014_05_last_update_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
7. 0.003 0.008 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2014_06 (cost=4.18..11.31 rows=3 width=119) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
8. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2014_06_last_update_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
9. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2014_07 (cost=4.18..11.31 rows=3 width=119) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
10. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2014_07_last_update_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
11. 0.001 0.009 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2014_08 (cost=4.18..11.31 rows=3 width=119) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
12. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2014_08_last_update_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
13. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2014_09 (cost=4.18..11.31 rows=3 width=119) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
14. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2014_09_last_update_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
15. 0.001 0.010 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2014_10 (cost=4.18..11.31 rows=3 width=119) (actual time=0.010..0.010 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
16. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2014_10_last_update_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
17. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2014_11 (cost=4.18..11.31 rows=3 width=119) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
18. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2014_11_last_update_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
19. 0.001 0.001 ↓ 0.0 0 1

Seq Scan on session_play_2014_12 (cost=0.00..19.62 rows=3 width=119) (actual time=0.001..0.001 rows=0 loops=1)

  • Filter: ((date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone) AND (date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)))
20. 0.001 0.008 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2015_01 (cost=4.18..11.31 rows=3 width=119) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
21. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2015_01_last_update_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
22. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2015_02 (cost=4.18..11.31 rows=3 width=119) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
23. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2015_02_last_update_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
24. 0.000 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2015_03 (cost=4.18..11.31 rows=3 width=119) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
25. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2015_03_last_update_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
26. 0.005 0.009 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2015_04 (cost=4.18..11.31 rows=3 width=119) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
27. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2015_04_last_update_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
28. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2015_05 (cost=4.18..11.31 rows=3 width=119) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
29. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2015_05_last_update_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
30. 0.003 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2015_06 (cost=4.18..11.31 rows=3 width=119) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
31. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2015_06_last_update_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
32. 0.002 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2015_07 (cost=4.18..11.31 rows=3 width=119) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
33. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2015_07_last_update_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
34. 0.003 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2015_08 (cost=4.18..11.31 rows=3 width=119) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
35. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2015_08_last_update_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
36. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2015_09 (cost=4.18..11.31 rows=3 width=119) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
37. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2015_09_last_update_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
38. 0.000 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2015_10 (cost=4.18..11.31 rows=3 width=119) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
39. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2015_10_last_update_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
40. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2015_11 (cost=4.18..11.31 rows=3 width=119) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
41. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2015_11_last_update_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
42. 0.000 0.008 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2015_12 (cost=4.18..11.31 rows=3 width=119) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
43. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2015_12_last_update_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
44. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2016_01 (cost=4.18..11.31 rows=3 width=119) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
45. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2016_01_last_update_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
46. 0.000 0.008 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2016_02 (cost=4.18..11.31 rows=3 width=119) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
47. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2016_02_last_update_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
48. 0.003 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2016_03 (cost=4.18..11.31 rows=3 width=119) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
49. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2016_03_last_update_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
50. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2016_04 (cost=4.18..11.31 rows=3 width=119) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
51. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2016_04_last_update_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
52. 0.005 0.008 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2016_05 (cost=4.18..11.31 rows=3 width=119) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
53. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2016_05_date_lastupdate_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
54. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2016_06 (cost=4.18..11.31 rows=3 width=119) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
55. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2016_06_date_lastupdate_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
56. 0.003 0.008 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2016_07 (cost=4.18..11.31 rows=3 width=119) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
57. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2016_07_date_lastupdate_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
58. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2016_08 (cost=4.18..11.31 rows=3 width=119) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
59. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2016_08_date_lastupdate_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
60. 0.000 0.008 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2016_09 (cost=4.18..11.31 rows=3 width=119) (actual time=0.008..0.008 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
61. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2016_09_date_lastupdate_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
62. 0.000 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2016_10 (cost=4.18..11.31 rows=3 width=119) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
63. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2016_10_date_lastupdate_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
64. 0.002 0.009 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2016_11 (cost=4.18..11.31 rows=3 width=119) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
65. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2016_11_date_lastupdate_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
66. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2016_12 (cost=4.18..11.31 rows=3 width=119) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
67. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2016_12_date_lastupdate_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
68. 0.001 0.009 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2017_01 (cost=4.18..11.31 rows=3 width=119) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
69. 0.008 0.008 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2017_01_date_lastupdate_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
70. 0.003 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2017_02 (cost=4.18..11.31 rows=3 width=119) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
71. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2017_02_date_lastupdate_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
72. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2017_03 (cost=4.18..11.31 rows=3 width=119) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
73. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2017_03_date_lastupdate_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
74. 0.009 0.013 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2017_04 (cost=4.18..11.31 rows=3 width=119) (actual time=0.013..0.013 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
75. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2017_04_date_lastupdate_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
76. 0.000 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2017_05 (cost=4.18..11.31 rows=3 width=119) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
77. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2017_05_date_lastupdate_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
78. 0.003 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2017_06 (cost=4.18..11.31 rows=3 width=119) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
79. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2017_06_date_lastupdate_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
80. 0.001 0.006 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2017_07 (cost=4.18..11.31 rows=3 width=119) (actual time=0.006..0.006 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
81. 0.005 0.005 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2017_07_date_lastupdate_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.005..0.005 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
82. 0.000 0.007 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2017_08 (cost=4.18..11.31 rows=3 width=119) (actual time=0.007..0.007 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
83. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2017_08_date_lastupdate_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
84. 0.001 0.005 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2017_09 (cost=4.18..11.31 rows=3 width=119) (actual time=0.005..0.005 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
85. 0.004 0.004 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2017_09_date_lastupdate_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
86. 0.018 0.018 ↓ 0.0 0 1

Index Scan using session_play_2017_11_date_lastupdate_idx on session_play_2017_11 (cost=0.42..8.44 rows=1 width=62) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=3
87. 0.011 0.011 ↓ 0.0 0 1

Index Scan using session_play_2017_12_date_lastupdate_idx on session_play_2017_12 (cost=0.43..8.46 rows=1 width=62) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=3
88. 0.011 0.011 ↓ 0.0 0 1

Index Scan using session_play_2018_01_date_lastupdate_idx on session_play_2018_01 (cost=0.43..8.46 rows=1 width=62) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=3
89. 0.010 0.010 ↓ 0.0 0 1

Index Scan using session_play_2018_02_date_lastupdate_idx on session_play_2018_02 (cost=0.43..8.46 rows=1 width=62) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=3
90. 0.009 0.009 ↓ 0.0 0 1

Index Scan using session_play_2018_03_date_lastupdate_idx on session_play_2018_03 (cost=0.43..8.46 rows=1 width=62) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=3
91. 0.010 0.010 ↓ 0.0 0 1

Index Scan using session_play_2018_04_date_lastupdate_idx on session_play_2018_04 (cost=0.43..8.46 rows=1 width=62) (actual time=0.010..0.010 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=3
92. 0.009 0.009 ↓ 0.0 0 1

Index Scan using session_play_2018_05_date_lastupdate_idx on session_play_2018_05 (cost=0.43..8.46 rows=1 width=62) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=3
93. 0.009 0.009 ↓ 0.0 0 1

Index Scan using session_play_2018_06_date_lastupdate_idx on session_play_2018_06 (cost=0.43..8.46 rows=1 width=62) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=3
94. 0.009 0.009 ↓ 0.0 0 1

Index Scan using session_play_2018_07_date_lastupdate_idx on session_play_2018_07 (cost=0.43..8.46 rows=1 width=62) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=3
95. 0.009 0.009 ↓ 0.0 0 1

Index Scan using session_play_2018_08_date_lastupdate_idx on session_play_2018_08 (cost=0.43..8.46 rows=1 width=62) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=3
96. 0.007 0.007 ↓ 0.0 0 1

Index Scan using session_play_2018_09_date_lastupdate_idx on session_play_2018_09 (cost=0.43..8.46 rows=1 width=62) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=3
97. 0.008 0.008 ↓ 0.0 0 1

Index Scan using session_play_2018_10_date_lastupdate_idx on session_play_2018_10 (cost=0.43..8.46 rows=1 width=62) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=3
98. 0.008 0.008 ↓ 0.0 0 1

Index Scan using session_play_2018_11_date_lastupdate_idx on session_play_2018_11 (cost=0.44..8.46 rows=1 width=62) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=3
99. 0.007 0.007 ↓ 0.0 0 1

Index Scan using session_play_2018_12_date_lastupdate_idx on session_play_2018_12 (cost=0.44..8.46 rows=1 width=62) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=3
100. 0.008 0.008 ↓ 0.0 0 1

Index Scan using session_play_2019_01_date_lastupdate_idx on session_play_2019_01 (cost=0.44..8.46 rows=1 width=62) (actual time=0.008..0.008 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=3
101. 0.068 0.068 ↑ 37.0 1 1

Index Scan using session_play_2019_02_date_lastupdate_idx on session_play_2019_02 (cost=0.43..10.49 rows=37 width=62) (actual time=0.067..0.068 rows=1 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=3 read=1 dirtied=1
102. 0.002 0.009 ↓ 0.0 0 1

Bitmap Heap Scan on session_play_2019_03 (cost=4.18..11.31 rows=3 width=119) (actual time=0.009..0.009 rows=0 loops=1)

  • Recheck Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1
103. 0.007 0.007 ↓ 0.0 0 1

Bitmap Index Scan on session_play_2019_03_date_lastupdate_idx (cost=0.00..4.18 rows=3 width=0) (actual time=0.007..0.007 rows=0 loops=1)

  • Index Cond: ((date_lastupdate > ('2019-02-07 16:47:15.729411+00'::timestamp with time zone - '00:01:00'::interval)) AND (date_lastupdate <= '2019-02-07 16:47:25.909588+00'::timestamp with time zone))
  • Buffers: shared hit=1