explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Zezi

Settings
# exclusive inclusive rows x rows loops node
1. 0.034 41.476 ↑ 1.0 1 1

Aggregate (cost=2,773.29..2,773.30 rows=1 width=72) (actual time=41.476..41.476 rows=1 loops=1)

2. 0.369 41.442 ↓ 6.0 6 1

Bitmap Heap Scan on protection_job_run_entities (cost=2,716.93..2,773.28 rows=1 width=8) (actual time=41.197..41.442 rows=6 loops=1)

  • Recheck Cond: ((job_id = 2340) AND (entity_id = 102))
  • Filter: ((is_full_backup IS NULL) AND (start_time_usecs >= '1578502213755482'::bigint) AND (start_time_usecs <= '1581094213755482'::bigint) AND (data_written_size_bytes > 0) AND (source_delta_size_bytes > 0) AND ((cluster_identifier)::text = '998663406507174:1556895109547'::text) AND (status = 4))
  • Rows Removed by Filter: 13
  • Heap Blocks: exact=15
3. 0.064 41.073 ↓ 0.0 0 1

BitmapAnd (cost=2,716.93..2,716.93 rows=14 width=0) (actual time=41.073..41.073 rows=0 loops=1)

4. 1.430 1.430 ↑ 1,154.2 19 1

Bitmap Index Scan on protection_job_run_entities_n3 (cost=0.00..413.04 rows=21,929 width=0) (actual time=1.430..1.430 rows=19 loops=1)

  • Index Cond: (job_id = 2340)
5. 39.579 39.579 ↑ 1.1 113,656 1

Bitmap Index Scan on protection_job_run_entities_n5 (cost=0.00..2,303.64 rows=122,543 width=0) (actual time=39.579..39.579 rows=113,656 loops=1)

  • Index Cond: (entity_id = 102)
Planning time : 1.435 ms
Execution time : 41.662 ms