explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 24mST

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.128 ↑ 3.8 26 1

``` Append (cost=0.42..230.12 rows=100 width=185) (actual time=0.093..0.128 rows=26 loops=1)

  • Subplans Removed: 32
2. 0.002 0.020 ↓ 0.0 0 1

Bitmap Heap Scan on public.notifications_summary_org_part_23_wl2_2019_w32 (cost=2.01..19.89 rows=3 width=177) (actual time=0.020..0.020 rows=0 loops=1)

  • Output: notifications_summary_org_part_23_wl2_2019_w32.notification_uuid, notifications_summary_org_part_23_wl2_2019_w32.ntfn_id, notifications_summary_org_part_23_wl2_2019_w32.organization_uuid, notifications_summary_org_part_23_wl2_2019_w32.category, notifications_summary_org_part_23_wl2_2019_w32.type, notifications_summary_org_part_23_wl2_2019_w32.ev
  • Recheck Cond: (notifications_summary_org_part_23_wl2_2019_w32.event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: ((notifications_summary_org_part_23_wl2_2019_w32.created_date <= '2019-09-09 16:00:07.347029+00'::timestamp with time zone) AND (notifications_summary_org_part_23_wl2_2019_w32.organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid) AND (notifications_summary_org_part_23_wl2_2019_w32.created_date >= ('2019-09-09 16:00:07.347029+00'::tim
3. 0.018 0.018 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w32_event_uuid_idx (cost=0.00..2.01 rows=12 width=0) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: (notifications_summary_org_part_23_wl2_2019_w32.event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
4. 0.000 0.017 ↓ 0.0 0 1

Bitmap Heap Scan on public.notifications_summary_org_part_23_wl2_2019_w33 (cost=1.98..15.31 rows=9 width=186) (actual time=0.017..0.017 rows=0 loops=1)

  • Output: notifications_summary_org_part_23_wl2_2019_w33.notification_uuid, notifications_summary_org_part_23_wl2_2019_w33.ntfn_id, notifications_summary_org_part_23_wl2_2019_w33.organization_uuid, notifications_summary_org_part_23_wl2_2019_w33.category, notifications_summary_org_part_23_wl2_2019_w33.type, notifications_summary_org_part_23_wl2_2019_w33.ev
  • Recheck Cond: (notifications_summary_org_part_23_wl2_2019_w33.event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: ((notifications_summary_org_part_23_wl2_2019_w33.created_date <= '2019-09-09 16:00:07.347029+00'::timestamp with time zone) AND (notifications_summary_org_part_23_wl2_2019_w33.organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid) AND (notifications_summary_org_part_23_wl2_2019_w33.created_date >= ('2019-09-09 16:00:07.347029+00'::tim
5. 0.017 0.017 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w33_event_uuid_idx (cost=0.00..1.98 rows=9 width=0) (actual time=0.017..0.017 rows=0 loops=1)

  • Index Cond: (notifications_summary_org_part_23_wl2_2019_w33.event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
6. 0.000 0.011 ↓ 0.0 0 1

Bitmap Heap Scan on public.notifications_summary_org_part_23_wl2_2019_w34 (cost=2.01..19.87 rows=12 width=187) (actual time=0.011..0.011 rows=0 loops=1)

  • Output: notifications_summary_org_part_23_wl2_2019_w34.notification_uuid, notifications_summary_org_part_23_wl2_2019_w34.ntfn_id, notifications_summary_org_part_23_wl2_2019_w34.organization_uuid, notifications_summary_org_part_23_wl2_2019_w34.category, notifications_summary_org_part_23_wl2_2019_w34.type, notifications_summary_org_part_23_wl2_2019_w34.ev
  • Recheck Cond: (notifications_summary_org_part_23_wl2_2019_w34.event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: ((notifications_summary_org_part_23_wl2_2019_w34.created_date <= '2019-09-09 16:00:07.347029+00'::timestamp with time zone) AND (notifications_summary_org_part_23_wl2_2019_w34.organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid) AND (notifications_summary_org_part_23_wl2_2019_w34.created_date >= ('2019-09-09 16:00:07.347029+00'::tim
7. 0.011 0.011 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w34_event_uuid_idx (cost=0.00..2.01 rows=12 width=0) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (notifications_summary_org_part_23_wl2_2019_w34.event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
8. 0.001 0.010 ↓ 0.0 0 1

Bitmap Heap Scan on public.notifications_summary_org_part_23_wl2_2019_w35 (cost=2.04..24.36 rows=15 width=187) (actual time=0.010..0.010 rows=0 loops=1)

  • Output: notifications_summary_org_part_23_wl2_2019_w35.notification_uuid, notifications_summary_org_part_23_wl2_2019_w35.ntfn_id, notifications_summary_org_part_23_wl2_2019_w35.organization_uuid, notifications_summary_org_part_23_wl2_2019_w35.category, notifications_summary_org_part_23_wl2_2019_w35.type, notifications_summary_org_part_23_wl2_2019_w35.ev
  • Recheck Cond: (notifications_summary_org_part_23_wl2_2019_w35.event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: ((notifications_summary_org_part_23_wl2_2019_w35.created_date <= '2019-09-09 16:00:07.347029+00'::timestamp with time zone) AND (notifications_summary_org_part_23_wl2_2019_w35.organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid) AND (notifications_summary_org_part_23_wl2_2019_w35.created_date >= ('2019-09-09 16:00:07.347029+00'::tim
9. 0.009 0.009 ↓ 0.0 0 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w35_event_uuid_idx (cost=0.00..2.03 rows=15 width=0) (actual time=0.009..0.009 rows=0 loops=1)

  • Index Cond: (notifications_summary_org_part_23_wl2_2019_w35.event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
10. 0.042 0.061 ↑ 1.1 26 1

Bitmap Heap Scan on public.notifications_summary_org_part_23_wl2_2019_w36 (cost=2.00..38.65 rows=28 width=188) (actual time=0.033..0.061 rows=26 loops=1)

  • Output: notifications_summary_org_part_23_wl2_2019_w36.notification_uuid, notifications_summary_org_part_23_wl2_2019_w36.ntfn_id, notifications_summary_org_part_23_wl2_2019_w36.organization_uuid, notifications_summary_org_part_23_wl2_2019_w36.category, notifications_summary_org_part_23_wl2_2019_w36.type, notifications_summary_org_part_23_wl2_2019_w36.ev
  • Recheck Cond: (notifications_summary_org_part_23_wl2_2019_w36.event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: ((notifications_summary_org_part_23_wl2_2019_w36.created_date <= '2019-09-09 16:00:07.347029+00'::timestamp with time zone) AND (notifications_summary_org_part_23_wl2_2019_w36.organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid) AND (notifications_summary_org_part_23_wl2_2019_w36.created_date >= ('2019-09-09 16:00:07.347029+00'::tim
  • Heap Blocks: exact=7
11. 0.019 0.019 ↓ 2.0 55 1

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w36_event_uuid_idx (cost=0.00..1.99 rows=28 width=0) (actual time=0.019..0.019 rows=55 loops=1)

  • Index Cond: (notifications_summary_org_part_23_wl2_2019_w36.event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
12. 0.005 0.005 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_23_wl2_2019_w37_event_uuid_idx on public.notifications_summary_org_part_23_wl2_2019_w37 (cost=0.14..3.17 rows=1 width=390) (actual time=0.005..0.005 rows=0 loops=1)

  • Output: notifications_summary_org_part_23_wl2_2019_w37.notification_uuid, notifications_summary_org_part_23_wl2_2019_w37.ntfn_id, notifications_summary_org_part_23_wl2_2019_w37.organization_uuid, notifications_summary_org_part_23_wl2_2019_w37.category, notifications_summary_org_part_23_wl2_2019_w37.type, notifications_summary_org_part_23_wl2_2019_w37.ev
  • Index Cond: (notifications_summary_org_part_23_wl2_2019_w37.event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: ((notifications_summary_org_part_23_wl2_2019_w37.created_date <= '2019-09-09 16:00:07.347029+00'::timestamp with time zone) AND (notifications_summary_org_part_23_wl2_2019_w37.organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid) AND (notifications_summary_org_part_23_wl2_2019_w37.created_date >= ('2019-09-09 16:00:07.347029+00'::tim
Planning time : 3,330.169 ms
Execution time : 0.691 ms