explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TCg

Settings
# exclusive inclusive rows x rows loops node
1. 285.695 20,503.992 ↑ 1.0 303,749 1

Sort (cost=296,621.62..296,776.21 rows=309,169 width=208) (actual time=20,459.728..20,503.992 rows=303,749 loops=1)

  • Sort Key: record_date DESC
  • Sort Method: external merge Disk: 32960kB
2. 20,181.803 20,218.297 ↑ 1.0 303,749 1

Bitmap Heap Scan on servicer_records (cost=2,773.30..269,092.99 rows=309,169 width=208) (actual time=53.091..20,218.297 rows=303,749 loops=1)

  • Recheck Cond: ((source_file)::text = 'fee'::text)
  • Heap Blocks: exact=70761
3. 36.494 36.494 ↑ 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=36.494..36.494 rows=308,398 loops=1)

  • Index Cond: ((source_file)::text = 'fee'::text)
Planning time : 0.625 ms
Execution time : 20,622.254 ms