explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qYcQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.067 0.067 ↓ 0.0 0 1

Append (cost=0.43..129.80 rows=54 width=241) (actual time=0.067..0.067 rows=0 loops=1)

  • Subplans Removed: 47
  • -> Index Scan using notifications_summary_org_part_1_wl2_2019_w31_ntfn_id_idx on notifications_summary_org_part_1_wl2_2019_w31 (cost=0.43..1.96 rows=1 width=177) (actual time=0.016..0.016 rows=0 loop
  • Index Cond: ((ntfn_id)::text = '06ae37e0-2f5f-40ce-a54e-c3c45f456836'::text)
  • Filter: ((organization_uuid = '9179fd37-1322-4957-8a99-7e2056388b4f'::uuid) AND (created_date <= CURRENT_TIMESTAMP) AND (created_date >= (CURRENT_TIMESTAMP - '31 days'::interval)))
  • -> Index Scan using notifications_summary_org_part_1_wl2_2019_w32_ntfn_id_idx on notifications_summary_org_part_1_wl2_2019_w32 (cost=0.43..1.96 rows=1 width=177) (actual time=0.010..0.010 rows=0 loop
  • Index Cond: ((ntfn_id)::text = '06ae37e0-2f5f-40ce-a54e-c3c45f456836'::text)
  • Filter: ((organization_uuid = '9179fd37-1322-4957-8a99-7e2056388b4f'::uuid) AND (created_date <= CURRENT_TIMESTAMP) AND (created_date >= (CURRENT_TIMESTAMP - '31 days'::interval)))
  • -> Index Scan using notifications_summary_org_part_1_wl2_2019_w33_ntfn_id_idx on notifications_summary_org_part_1_wl2_2019_w33 (cost=0.42..3.75 rows=2 width=186) (actual time=0.013..0.013 rows=0 loop
  • Index Cond: ((ntfn_id)::text = '06ae37e0-2f5f-40ce-a54e-c3c45f456836'::text)
  • Filter: ((organization_uuid = '9179fd37-1322-4957-8a99-7e2056388b4f'::uuid) AND (created_date <= CURRENT_TIMESTAMP) AND (created_date >= (CURRENT_TIMESTAMP - '31 days'::interval)))
  • -> Index Scan using notifications_summary_org_part_1_wl2_2019_w34_ntfn_id_idx on notifications_summary_org_part_1_wl2_2019_w34 (cost=0.42..3.45 rows=1 width=188) (actual time=0.010..0.010 rows=0 loop
  • Index Cond: ((ntfn_id)::text = '06ae37e0-2f5f-40ce-a54e-c3c45f456836'::text)
  • Filter: ((organization_uuid = '9179fd37-1322-4957-8a99-7e2056388b4f'::uuid) AND (created_date <= CURRENT_TIMESTAMP) AND (created_date >= (CURRENT_TIMESTAMP - '31 days'::interval)))
  • -> Index Scan using notifications_summary_org_part_1_wl2_2019_w35_ntfn_id_idx on notifications_summary_org_part_1_wl2_2019_w35 (cost=0.42..3.46 rows=1 width=188) (actual time=0.010..0.010 rows=0 loop
  • Index Cond: ((ntfn_id)::text = '06ae37e0-2f5f-40ce-a54e-c3c45f456836'::text)
  • Filter: ((organization_uuid = '9179fd37-1322-4957-8a99-7e2056388b4f'::uuid) AND (created_date <= CURRENT_TIMESTAMP) AND (created_date >= (CURRENT_TIMESTAMP - '31 days'::interval)))
  • -> Index Scan using notifications_summary_org_part_1_wl2_2019_w36_ntfn_id_idx on notifications_summary_org_part_1_wl2_2019_w36 (cost=0.29..3.32 rows=1 width=189) (actual time=0.007..0.007 rows=0 loop
  • Index Cond: ((ntfn_id)::text = '06ae37e0-2f5f-40ce-a54e-c3c45f456836'::text)
  • Filter: ((organization_uuid = '9179fd37-1322-4957-8a99-7e2056388b4f'::uuid) AND (created_date <= CURRENT_TIMESTAMP) AND (created_date >= (CURRENT_TIMESTAMP - '31 days'::interval)))
Planning time : 264.410 ms
Execution time : 0.488 ms