explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NkMA

Settings
# exclusive inclusive rows x rows loops node
1. 0.075 5,126.709 ↑ 1.0 1 1

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

2. 0.256 5,126.634 ↓ 6.0 6 1

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

3. 0.000 5,126.378 ↓ 6.0 6 1

Limit (cost=3,982.69..29,109.14 rows=1 width=91) (actual time=5,126.370..5,126.378 rows=6 loops=1)

4. 28.381 5,144.159 ↓ 6.0 6 1

Gather (cost=3,982.69..29,109.14 rows=1 width=91) (actual time=5,126.367..5,144.159 rows=6 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 3,447.192 5,115.778 ↓ 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=5,115.752..5,115.778 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=1,380
6. 1,668.586 1,668.586 ↑ 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=5,005.757..5,005.757 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 : 6.346 ms
Execution time : 5,146.521 ms