explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uybg

Settings
# exclusive inclusive rows x rows loops node
1. 167.831 2,808.566 ↓ 0.0 0 1

HashAggregate (cost=701,705.52..703,025.15 rows=131,963 width=53) (actual time=2,808.566..2,808.566 rows=0 loops=1)

  • Group Key: ds.document_id, ds.company_id
  • Filter: (every((s.id IS NOT NULL)) AND (max(s.date_created) > '2019-10-20 00:00:00+00'::timestamp with time zone))
  • Rows Removed by Filter: 171,684
2. 41.081 2,640.735 ↓ 1.0 285,111 1

Nested Loop Left Join (cost=0.56..698,859.93 rows=284,559 width=98) (actual time=0.019..2,640.735 rows=285,111 loops=1)

3. 33.655 33.655 ↓ 1.0 285,111 1

Seq Scan on document_signers ds (cost=0.00..8,781.59 rows=284,559 width=69) (actual time=0.006..33.655 rows=285,111 loops=1)

4. 2,565.999 2,565.999 ↑ 1.0 1 285,111

Index Scan using ix_signatures_document_id on signatures s (cost=0.56..2.42 rows=1 width=98) (actual time=0.008..0.009 rows=1 loops=285,111)

  • Index Cond: ((document_id)::text = (ds.document_id)::text)
  • Filter: (role_id = ds.role_id)
  • Rows Removed by Filter: 1
Planning time : 0.567 ms
Execution time : 2,810.125 ms