explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ce1z

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

Limit (cost=283,691.41..283,691.41 rows=1 width=87) (actual time=6,378.741..6,378.744 rows=1 loops=1)

2. 0.513 6,378.740 ↑ 1.0 1 1

Sort (cost=283,691.41..283,691.41 rows=1 width=87) (actual time=6,378.740..6,378.740 rows=1 loops=1)

  • Sort Key: id DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 6,378.227 6,378.227 ↓ 776.0 776 1

Index Scan using idx_optimizer_job_optimizer_job_state_optimizer_job_type_create on optimizer_job groupoptim0_ (cost=0.56..283,691.40 rows=1 width=87) (actual time=137.623..6,378.227 rows=776 loops=1)

  • Index Cond: ((optimizer_job_type)::text = 'GROUP'::text)
  • Filter: (origin_id = '4878431'::bigint)
  • Rows Removed by Filter: 48677
Planning time : 0.351 ms
Execution time : 6,378.787 ms