explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lDM6

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 1,353.686 ↑ 1.0 1 1

Aggregate (cost=72.49..72.50 rows=1 width=8) (actual time=1,353.685..1,353.686 rows=1 loops=1)

  • Output: count(1)
  • Buffers: shared hit=761279
2. 0.000 1,353.682 ↓ 0.0 0 1

Nested Loop (cost=1.00..72.49 rows=1 width=0) (actual time=1,353.682..1,353.682 rows=0 loops=1)

  • Buffers: shared hit=761279
3. 820.528 820.528 ↓ 36,990.0 184,950 1

Index Scan using sr_srv_rendered_planned_date_idx on public.sr_srv_rendered r (cost=0.56..17.59 rows=5 width=4) (actual time=0.065..820.528 rows=184,950 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=171688
4. 554.850 554.850 ↓ 0.0 0 184,950

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.003..0.003 rows=0 loops=184,950)

  • 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=589591
Planning time : 7.333 ms
Execution time : 1,353.821 ms