explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VijR

Settings
# exclusive inclusive rows x rows loops node
1. 3.959 4,377.608 ↓ 8.0 7,251 1

Unique (cost=65,455.73..65,460.29 rows=908 width=376) (actual time=4,370.825..4,377.608 rows=7,251 loops=1)

2. 20.041 4,373.649 ↓ 10.2 9,285 1

Sort (cost=65,455.73..65,458.01 rows=912 width=376) (actual time=4,370.823..4,373.649 rows=9,285 loops=1)

  • Sort Key: client_id, obj_id DESC
  • Sort Method: external merge Disk: 2672kB
3. 4,337.628 4,353.608 ↓ 10.2 9,285 1

Bitmap Heap Scan on application (cost=3,508.53..65,410.89 rows=912 width=376) (actual time=130.876..4,353.608 rows=9,285 loops=1)

  • Recheck Cond: (application_state_id = 10)
  • Filter: ((((now())::date - (create_time)::date) >= 0) AND (((now())::date - (create_time)::date) <= 30))
  • Rows Removed by Filter: 171916
  • Heap Blocks: exact=46424
4. 15.980 15.980 ↓ 1.0 183,818 1

Bitmap Index Scan on application_state_id_idx (cost=0.00..3,508.30 rows=182,383 width=0) (actual time=15.980..15.980 rows=183,818 loops=1)

  • Index Cond: (application_state_id = 10)
Planning time : 0.291 ms
Execution time : 4,380.128 ms