explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JuLr

Settings
# exclusive inclusive rows x rows loops node
1. 167.220 816.464 ↑ 173.0 163 1

GroupAggregate (cost=52,876.98..65,272.24 rows=28,192 width=153) (actual time=367.129..816.464 rows=163 loops=1)

  • Group Key: account_id, cluster_identifier, parent_source_id, view_box_id, job_id
  • Sort Key: cluster_identifier, parent_source_id, view_box_id, job_id
  • Sort Method: external merge Disk: 27968kB
2. 549.874 649.244 ↑ 1.0 281,693 1

Sort (cost=52,876.98..53,581.24 rows=281,703 width=93) (actual time=367.022..649.244 rows=281,693 loops=1)

3. 99.370 99.370 ↑ 1.0 281,693 1

Seq Scan on protection_job_runs (cost=0.00..12,932.99 rows=281,703 width=93) (actual time=0.016..99.370 rows=281,693 loops=1)

  • Filter: ((account_id)::text = '0012F00000JeVgYQAV'::text)
  • Rows Removed by Filter: 226