explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 717c

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1,378.272 ↑ 1.0 1 1

Limit (cost=72.78..72.79 rows=1 width=8) (actual time=1,378.272..1,378.272 rows=1 loops=1)

  • Output: (count(r.id))
  • Buffers: shared hit=754999
2. 0.005 1,378.270 ↑ 1.0 1 1

Aggregate (cost=72.78..72.79 rows=1 width=8) (actual time=1,378.270..1,378.270 rows=1 loops=1)

  • Output: count(r.id)
  • Buffers: shared hit=754999
3. 108.628 1,378.265 ↓ 0.0 0 1

Nested Loop (cost=1.00..72.77 rows=1 width=4) (actual time=1,378.265..1,378.265 rows=0 loops=1)

  • Output: r.id
  • Buffers: shared hit=754999
4. 903.045 903.045 ↓ 36,659.2 183,296 1

Index Scan using sr_srv_rendered_planned_date_idx on public.sr_srv_rendered r (cost=0.56..17.88 rows=5 width=4) (actual time=0.041..903.045 rows=183,296 loops=1)

  • Output: r.id
  • Index Cond: ((r.planned_date >= '2019-07-01'::date) AND (r.planned_date < '2019-08-01'::date))
  • Buffers: shared hit=170466
5. 366.592 366.592 ↓ 0.0 0 183,296

Index Scan using sr_srv_rendered_q_rate_srv_rendered_id_idx on public.sr_srv_rendered_q_rate q (cost=0.43..10.97 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=183,296)

  • Output: q.id, q.rate_id, q.srv_rendered_id, q.clause_id, q.aud_who, q.aud_when, q.aud_source, q.aud_who_create, q.aud_when_create, q.aud_source_create, q.planned_date
  • Index Cond: (q.srv_rendered_id = r.id)
  • Filter: (q.rate_id = 1655)
  • Rows Removed by Filter: 0
  • Buffers: shared hit=584533
Planning time : 3.226 ms
Execution time : 1,378.448 ms