explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HNGy

Settings
# exclusive inclusive rows x rows loops node
1. 0.885 105,925.686 ↑ 1.0 3,000 1

Limit (cost=143.37..11,717.72 rows=3,000 width=346) (actual time=0.633..105,925.686 rows=3,000 loops=1)

  • Buffers: shared hit=2,553 read=458 written=76
2. 0.795 105,924.801 ↑ 1.4 3,000 1

Append (cost=143.37..16,355.17 rows=4,202 width=346) (actual time=0.632..105,924.801 rows=3,000 loops=1)

  • Buffers: shared hit=2,553 read=458 written=76
3. 3.768 4.153 ↑ 1.8 2,199 1

Bitmap Heap Scan on contact_reports_p2020_09_01 cr (cost=143.37..15,452.72 rows=3,985 width=346) (actual time=0.632..4.153 rows=2,199 loops=1)

  • Heap Blocks: exact=2,185
  • Buffers: shared hit=2,203
4. 0.385 0.385 ↑ 1.8 2,199 1

Bitmap Index Scan on contact_reports_p2020_09_01_identity_id_report_date_time_idx (cost=0..142.38 rows=3,985 width=0) (actual time=0.385..0.385 rows=2,199 loops=1)

  • Index Cond: ((cr.identity_id = 3,813,185) AND (cr.report_date_time >= '2020-09-01 19:30:00'::timestamp without time zone) AND (cr.report_date_time <= '2020-09-02 19:30:00'::timestamp without time zone))
  • Buffers: shared hit=18
5. 105,919.853 105,919.853 ↓ 3.7 801 1

Index Scan using contact_reports_p2020_09_02_identity_id_report_date_time_idx on contact_reports_p2020_09_02 cr_1 (cost=0.56..881.44 rows=217 width=346) (actual time=0.014..105,919.853 rows=801 loops=1)

  • Index Cond: ((cr_1.identity_id = 3,813,185) AND (cr_1.report_date_time >= '2020-09-01 19:30:00'::timestamp without time zone) AND (cr_1.report_date_time <= '2020-09-02 19:30:00'::timestamp without time zone))
  • Buffers: shared hit=350 read=458 written=76
Planning time : 39.729 ms
Execution time : 105,926.431 ms