explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TDcN

Settings
# exclusive inclusive rows x rows loops node
1. 680,575.281 690,240.006 ↓ 3.2 3,540,269 1

Bitmap Heap Scan on lddb (cost=309,423.82..1,409,039.15 rows=1,103,834 width=1,415) (actual time=11,062.798..690,240.006 rows=3,540,269 loops=1)

  • Recheck Cond: ((depmaxmodified >= '2019-09-04 01:59:30+02'::timestamp with time zone) AND (depmaxmodified <= '2019-09-05 02:00:00+02'::timestamp with time zone) AND (collection = 'bib'::text))
  • Heap Blocks: exact=2,682,683
  • Buffers: shared hit=15,037,762 read=3,582,961 dirtied=255
2. 950.475 9,664.725 ↓ 0.0 0 1

BitmapAnd (cost=309,423.82..309,423.82 rows=1,103,908 width=0) (actual time=9,664.725..9,664.725 rows=0 loops=1)

  • Buffers: shared hit=156,789
3. 1,829.108 1,829.108 ↑ 1.2 3,882,997 1

Bitmap Index Scan on idx_lddb_dep_max_modified (cost=0.00..82,968.82 rows=4,591,325 width=0) (actual time=1,829.108..1,829.108 rows=3,882,997 loops=1)

  • Index Cond: ((depmaxmodified >= '2019-09-04 01:59:30+02'::timestamp with time zone) AND (depmaxmodified <= '2019-09-05 02:00:00+02'::timestamp with time zone))
  • Buffers: shared hit=16,707
4. 6,885.142 6,885.142 ↑ 1.1 12,325,803 1

Bitmap Index Scan on idx_lddb_collection (cost=0.00..225,902.84 rows=13,702,837 width=0) (actual time=6,885.141..6,885.142 rows=12,325,803 loops=1)

  • Index Cond: (collection = 'bib'::text)
  • Buffers: shared hit=140,082
Planning time : 1.763 ms
Execution time : 690,861.851 ms