explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LSLP

Settings
# exclusive inclusive rows x rows loops node
1. 0.578 26,002.921 ↓ 1.2 1,120 1

Append (cost=0.29..4,545.97 rows=940 width=37) (actual time=5,820.442..26,002.921 rows=1,120 loops=1)

  • Buffers: shared hit=28 read=1360 dirtied=1
  • Subplans Removed: 39
2. 22,773.175 23,008.566 ↓ 1.3 837 1

Bitmap Heap Scan on vi_cdrs_2019_09 (cost=27.15..3,375.98 rows=647 width=37) (actual time=5,820.441..23,008.566 rows=837 loops=1)

  • Recheck Cond: ((service_id)::text = 'MUA-C-00053-V01'::text)
  • Filter: (created > (CURRENT_TIMESTAMP - '30 days'::interval))
  • Rows Removed by Filter: 261
  • Heap Blocks: exact=1093
  • Buffers: shared read=1101
3. 235.391 235.391 ↓ 1.3 1,098 1

Bitmap Index Scan on vi_cdrs_2019_09_service_id_idx (cost=0.00..26.99 rows=875 width=0) (actual time=235.391..235.391 rows=1,098 loops=1)

  • Index Cond: ((service_id)::text = 'MUA-C-00053-V01'::text)
  • Buffers: shared read=8
4. 2,993.647 2,993.777 ↓ 1.1 283 1

Bitmap Heap Scan on vi_cdrs_2019_10 (cost=10.39..984.63 rows=254 width=37) (actual time=11.865..2,993.777 rows=283 loops=1)

  • Recheck Cond: ((service_id)::text = 'MUA-C-00053-V01'::text)
  • Filter: (created > (CURRENT_TIMESTAMP - '30 days'::interval))
  • Heap Blocks: exact=283
  • Buffers: shared hit=28 read=259 dirtied=1
5. 0.130 0.130 ↓ 1.1 283 1

Bitmap Index Scan on vi_cdrs_2019_10_service_id_idx (cost=0.00..10.33 rows=254 width=0) (actual time=0.130..0.130 rows=283 loops=1)

  • Index Cond: ((service_id)::text = 'MUA-C-00053-V01'::text)
  • Buffers: shared hit=4
Planning time : 265.466 ms
Execution time : 26,003.459 ms