explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nhm8

Settings
# exclusive inclusive rows x rows loops node
1. 0.279 124.973 ↑ 1.0 1 1

Aggregate (cost=10,243.55..10,243.62 rows=1 width=680) (actual time=124.972..124.973 rows=1 loops=1)

  • Buffers: shared hit=7 read=496
2. 0.176 124.694 ↑ 11.1 156 1

Nested Loop (cost=0.71..10,148.41 rows=1,729 width=84) (actual time=30.829..124.694 rows=156 loops=1)

  • Buffers: shared hit=7 read=496
3. 0.023 0.023 ↑ 1.0 1 1

Index Scan using nielsennsiprovantagexstations_provxstationorganizationid_idx on nielsennsiprovantagexstations s (cost=0.28..2.50 rows=1 width=4) (actual time=0.021..0.023 rows=1 loops=1)

  • Index Cond: (provantagexstationorganizationid = 772)
  • Buffers: shared hit=3
4. 0.166 124.495 ↑ 13.7 156 1

Append (cost=0.43..10,124.60 rows=2,131 width=88) (actual time=30.803..124.495 rows=156 loops=1)

  • Buffers: shared hit=4 read=496
5. 32.820 32.820 ↑ 11.2 4 1

Index Scan using tvsweep_201912_tvstationid_idx on tvsweep_201912 t (cost=0.43..2,689.82 rows=45 width=88) (actual time=30.801..32.820 rows=4 loops=1)

  • Index Cond: (tvstationid = s.nielsennsitvstationid)
  • Filter: ((ddate >= '2019-12-30 00:00:00'::timestamp without time zone) AND (ddate < '2020-03-29 00:00:00'::timestamp without time zone) AND (cendtime > '15:00:00'::time without time zone) AND (cstarttime < '16:00:00'::time without time zone) AND ((viewingtypeid)::text = 'LS'::text) AND (((dayofweekmask)::integer & 14) <> 0))
  • Rows Removed by Filter: 2,972
  • Buffers: shared hit=1 read=131
6. 22.663 22.663 ↑ 13.1 56 1

Index Scan using tvsweep_202001_tvstationid_idx on tvsweep_202001 t_1 (cost=0.43..2,465.57 rows=734 width=88) (actual time=9.430..22.663 rows=56 loops=1)

  • Index Cond: (tvstationid = s.nielsennsitvstationid)
  • Filter: ((ddate >= '2019-12-30 00:00:00'::timestamp without time zone) AND (ddate < '2020-03-29 00:00:00'::timestamp without time zone) AND (cendtime > '15:00:00'::time without time zone) AND (cstarttime < '16:00:00'::time without time zone) AND ((viewingtypeid)::text = 'LS'::text) AND (((dayofweekmask)::integer & 14) <> 0))
  • Rows Removed by Filter: 2,920
  • Buffers: shared hit=1 read=119
7. 27.608 27.608 ↑ 14.3 48 1

Index Scan using tvsweep_202002_tvstationid_idx on tvsweep_202002 t_2 (cost=0.43..2,304.81 rows=688 width=88) (actual time=4.210..27.608 rows=48 loops=1)

  • Index Cond: (tvstationid = s.nielsennsitvstationid)
  • Filter: ((ddate >= '2019-12-30 00:00:00'::timestamp without time zone) AND (ddate < '2020-03-29 00:00:00'::timestamp without time zone) AND (cendtime > '15:00:00'::time without time zone) AND (cstarttime < '16:00:00'::time without time zone) AND ((viewingtypeid)::text = 'LS'::text) AND (((dayofweekmask)::integer & 14) <> 0))
  • Rows Removed by Filter: 2,736
  • Buffers: shared hit=1 read=114
8. 41.238 41.238 ↑ 13.8 48 1

Index Scan using tvsweep_202003_tvstationid_idx on tvsweep_202003 t_3 (cost=0.43..2,664.40 rows=664 width=88) (actual time=4.534..41.238 rows=48 loops=1)

  • Index Cond: (tvstationid = s.nielsennsitvstationid)
  • Filter: ((ddate >= '2019-12-30 00:00:00'::timestamp without time zone) AND (ddate < '2020-03-29 00:00:00'::timestamp without time zone) AND (cendtime > '15:00:00'::time without time zone) AND (cstarttime < '16:00:00'::time without time zone) AND ((viewingtypeid)::text = 'LS'::text) AND (((dayofweekmask)::integer & 14) <> 0))
  • Rows Removed by Filter: 2,928
  • Buffers: shared hit=1 read=132
Planning time : 435.328 ms
Execution time : 125.272 ms