explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Nvkp

Settings
# exclusive inclusive rows x rows loops node
1. 196.846 2,782.590 ↑ 1,217.3 297 1

GroupAggregate (cost=298,251.45..317,068.42 rows=361,525 width=62) (actual time=2,018.774..2,782.590 rows=297 loops=1)

  • Group Key: cluster_identifier, job_id, parent_source_id, view_box_id
2. 1,815.550 2,585.744 ↑ 1.0 1,009,966 1

Sort (cost=298,251.45..300,785.07 rows=1,013,448 width=62) (actual time=2,018.753..2,585.744 rows=1,009,966 loops=1)

  • Sort Key: cluster_identifier, job_id, parent_source_id, view_box_id
  • Sort Method: external merge Disk: 71616kB
3. 637.464 770.194 ↑ 1.0 1,009,966 1

Bitmap Heap Scan on protection_job_runs (cost=27,954.65..120,946.75 rows=1,013,448 width=62) (actual time=148.522..770.194 rows=1,009,966 loops=1)

  • Recheck Cond: ((account_id)::text = '0015000002I3CkVAAV'::text)
  • Rows Removed by Index Recheck: 918643
  • Heap Blocks: exact=48746 lossy=26431
4. 132.730 132.730 ↑ 1.0 1,009,966 1

Bitmap Index Scan on protection_job_runs_aid (cost=0.00..27,701.29 rows=1,013,448 width=0) (actual time=132.730..132.730 rows=1,009,966 loops=1)

  • Index Cond: ((account_id)::text = '0015000002I3CkVAAV'::text)