explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2WFt

Settings
# exclusive inclusive rows x rows loops node
1. 0.090 121.648 ↑ 1.0 1 1

Aggregate (cost=29,109.15..29,109.17 rows=1 width=32) (actual time=121.648..121.648 rows=1 loops=1)

2. 0.376 121.558 ↓ 6.0 6 1

Subquery Scan on t (cost=3,982.69..29,109.15 rows=1 width=115) (actual time=95.153..121.558 rows=6 loops=1)

3. 0.000 121.182 ↓ 6.0 6 1

Limit (cost=3,982.69..29,109.14 rows=1 width=91) (actual time=94.784..121.182 rows=6 loops=1)

4. 96.672 127.194 ↓ 6.0 6 1

Gather (cost=3,982.69..29,109.14 rows=1 width=91) (actual time=94.781..127.194 rows=6 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 28.346 30.522 ↓ 2.0 2 3 / 3

Parallel Bitmap Heap Scan on forms t1 (cost=2,982.69..28,109.04 rows=1 width=91) (actual time=30.499..30.522 rows=2 loops=3)

  • Recheck Cond: ((effective_date >= '2020-05-01 05:00:00+00'::timestamp with time zone) AND (effective_date <= '2020-06-01 04:59:59.999+00'::timestamp with time zone))
  • Filter: ((NOT deleted) AND (updated_at >= '2020-05-01 04:00:00+00'::timestamp with time zone) AND (organization_id = '253e4a2e-cf11-4ce3-8974-6de0e9858d9f'::uuid) AND (form_type_code = '4'::numeric) AND (product = 1))
  • Rows Removed by Filter: 32,178
  • Heap Blocks: exact=3,178
6. 2.176 2.176 ↑ 1.0 96,556 1 / 3

Bitmap Index Scan on effective_date_forms (cost=0.00..2,982.69 rows=98,626 width=0) (actual time=6.529..6.529 rows=96,556 loops=1)

  • Index Cond: ((effective_date >= '2020-05-01 05:00:00+00'::timestamp with time zone) AND (effective_date <= '2020-06-01 04:59:59.999+00'::timestamp with time zone))
Planning time : 1.804 ms
Execution time : 128.730 ms