explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jgJ

Settings
# exclusive inclusive rows x rows loops node
1. 16,793.497 33,582.825 ↓ 0.0 0 1

Gather (cost=1,000.43..3,149.40 rows=100 width=876) (actual time=33,581.495..33,582.825 rows=0 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
  • Single Copy: true
2. 0.001 16,789.327 ↓ 0.0 0 1 / 2

Limit (cost=0.43..2,139.40 rows=100 width=876) (actual time=33,578.655..33,578.655 rows=0 loops=1)

3. 16,789.326 16,789.326 ↓ 0.0 0 1 / 2

Index Scan using submissions_created_at_index on submissions (cost=0.43..1,382,587.75 rows=64,638 width=876) (actual time=33,578.653..33,578.653 rows=0 loops=1)

  • Index Cond: (created_at > '2019-12-08 05:58:35.763983+05:30'::timestamp with time zone)
  • Filter: (batch_id = '002b42b9-a5de-4644-b94c-8ccac899b153'::uuid)
  • Rows Removed by Filter: 2298065
Planning time : 0.233 ms
Execution time : 33,582.926 ms