explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x3PF

Settings
# exclusive inclusive rows x rows loops node
1. 1.783 42.470 ↑ 1.0 1 1

Aggregate (cost=129,269.60..129,269.61 rows=1 width=8) (actual time=42.469..42.470 rows=1 loops=1)

2. 32.763 40.687 ↑ 1.1 33,697 1

Bitmap Heap Scan on messages m0 (cost=1,428.01..129,179.41 rows=36,074 width=8) (actual time=12.543..40.687 rows=33,697 loops=1)

  • Recheck Cond: (provider_id = 109,064)
  • Filter: (status = ANY ('{2,3,4}'::integer[]))
  • Heap Blocks: exact=29,149
3. 7.924 7.924 ↑ 1.1 33,881 1

Bitmap Index Scan on message_provider_id_appointment_id_index (cost=0.00..1,418.99 rows=36,074 width=0) (actual time=7.924..7.924 rows=33,881 loops=1)

  • Index Cond: (provider_id = 109,064)
Planning time : 0.082 ms
Execution time : 42.677 ms