explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ljHB

Settings
# exclusive inclusive rows x rows loops node
1. 89.267 542.286 ↑ 1.0 303,749 1

Sort (cost=273,804.12..273,958.70 rows=309,169 width=16) (actual time=519.869..542.286 rows=303,749 loops=1)

  • Sort Key: record_date DESC
  • Sort Method: quicksort Memory: 31293kB
2. 408.618 453.019 ↑ 1.0 303,749 1

Bitmap Heap Scan on servicer_records (cost=2,773.30..268,165.48 rows=309,169 width=16) (actual time=62.262..453.019 rows=303,749 loops=1)

  • Recheck Cond: ((source_file)::text = 'fee'::text)
  • Heap Blocks: exact=70761
3. 44.401 44.401 ↑ 1.0 308,398 1

Bitmap Index Scan on index_servicer_records_on_source_file (cost=0.00..2,757.84 rows=309,169 width=0) (actual time=44.401..44.401 rows=308,398 loops=1)

  • Index Cond: ((source_file)::text = 'fee'::text)
Planning time : 5.333 ms
Execution time : 564.164 ms