explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hdi6

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 3,869.310 ↓ 0.0 0 1

Limit (cost=19,965.41..35,995.56 rows=1 width=1,492) (actual time=3,869.310..3,869.310 rows=0 loops=1)

2. 3,610.360 3,869.308 ↓ 0.0 0 1

Bitmap Heap Scan on system_error_details (cost=19,965.41..35,995.56 rows=1 width=1,492) (actual time=3,869.307..3,869.308 rows=0 loops=1)

  • Recheck Cond: ((system_error_id = 2,737,150) AND (module = 'CImportDifferentialDataScript'::text) AND (ps_product_id = 61))
  • Filter: ((action IS NULL) AND (description = 'execute_db LINE 8: ... AND DATE_TRUNC( ''MINUTE'', e.event_datetime ) = ''0000-12-3... ^ /*req_id:aa641b3c0bd33e321ec36b2bd95af66f*/SELECT * FROM events e WHERE e.cid = 17,271 AND e.lease_interval_id = 16,716,812 AND DATE_TRUNC( ''MINUTE'', e.event_datetime ) = ''0000-12-31 22:00'' AND e.event_type_id IN ( 32,7,13,5,6,3,4,12,8,'::text))
  • Rows Removed by Filter: 103,090
  • Heap Blocks: exact=80,469
3. 12.122 258.948 ↓ 0.0 0 1

BitmapAnd (cost=19,965.41..19,965.41 rows=4,365 width=0) (actual time=258.948..258.948 rows=0 loops=1)

4. 31.724 31.724 ↓ 1.0 103,516 1

Bitmap Index Scan on system_error_details_system_error_id_idx (cost=0.00..1,875.82 rows=101,252 width=0) (actual time=31.724..31.724 rows=103,516 loops=1)

  • Index Cond: (system_error_id = 2,737,150)
5. 77.356 77.356 ↓ 1.0 221,633 1

Bitmap Index Scan on system_error_details_module_idx (cost=0.00..5,734.80 rows=218,449 width=0) (actual time=77.356..77.356 rows=221,633 loops=1)

  • Index Cond: (module = 'CImportDifferentialDataScript'::text)
6. 137.746 137.746 ↓ 1.0 668,558 1

Bitmap Index Scan on idx_system_error_details_ps_product_id (cost=0.00..12,354.29 rows=667,982 width=0) (actual time=137.746..137.746 rows=668,558 loops=1)

  • Index Cond: (ps_product_id = 61)
Planning time : 1.140 ms
Execution time : 3,869.759 ms