explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1RIk

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

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

  • Subplans Removed: 31
  • -> 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.042..0.042 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 - '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.026..0.026 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 - '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=1.666..1.666 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 - '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=2.943..2.943 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 - '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.45 rows=1 width=188) (actual time=2.671..2.671 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 - '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.31 rows=1 width=189) (actual time=2.737..2.737 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 - '31 days'::interval)))
  • -> Index Scan using notifications_summary_org_part_1_wl2_2019_w37_ntfn_id_idx on notifications_summary_org_part_1_wl2_2019_w37 (cost=0.14..3.17 rows=1 width=390) (actual time=0.014..0.014 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 - '31 days'::interval)))
  • -> Index Scan using notifications_summary_org_part_1_wl2_2019_w38_ntfn_id_idx on notifications_summary_org_part_1_wl2_2019_w38 (cost=0.14..3.17 rows=1 width=390) (actual time=0.009..0.009 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 - '31 days'::interval)))
  • -> Index Scan using notifications_summary_org_part_1_wl2_2019_w39_ntfn_id_idx on notifications_summary_org_part_1_wl2_2019_w39 (cost=0.14..3.17 rows=1 width=390) (actual time=0.007..0.008 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 - '31 days'::interval)))
  • -> Index Scan using notifications_summary_org_part_1_wl2_2019_w40_ntfn_id_idx on notifications_summary_org_part_1_wl2_2019_w40 (cost=0.14..3.17 rows=1 width=390) (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 - '31 days'::interval)))
  • -> Index Scan using notifications_summary_org_part_1_wl2_2019_w41_ntfn_id_idx on notifications_summary_org_part_1_wl2_2019_w41 (cost=0.14..3.17 rows=1 width=390) (actual time=0.009..0.009 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 - '31 days'::interval)))
  • -> Index Scan using notifications_summary_org_part_1_wl2_2019_w42_ntfn_id_idx on notifications_summary_org_part_1_wl2_2019_w42 (cost=0.14..3.17 rows=1 width=390) (actual time=0.012..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 - '31 days'::interval)))
  • -> Index Scan using notifications_summary_org_part_1_wl2_2019_w43_ntfn_id_idx on notifications_summary_org_part_1_wl2_2019_w43 (cost=0.14..3.17 rows=1 width=390) (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 - '31 days'::interval)))
  • -> Index Scan using notifications_summary_org_part_1_wl2_2019_w44_ntfn_id_idx on notifications_summary_org_part_1_wl2_2019_w44 (cost=0.14..3.17 rows=1 width=390) (actual time=0.006..0.006 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 - '31 days'::interval)))
  • -> Index Scan using notifications_summary_org_part_1_wl2_2019_w45_ntfn_id_idx on notifications_summary_org_part_1_wl2_2019_w45 (cost=0.14..3.17 rows=1 width=390) (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 - '31 days'::interval)))
  • -> Index Scan using notifications_summary_org_part_1_wl2_2019_w46_ntfn_id_idx on notifications_summary_org_part_1_wl2_2019_w46 (cost=0.14..3.17 rows=1 width=390) (actual time=0.008..0.008 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 - '31 days'::interval)))
  • -> Index Scan using notifications_summary_org_part_1_wl2_2019_w47_ntfn_id_idx on notifications_summary_org_part_1_wl2_2019_w47 (cost=0.14..3.17 rows=1 width=390) (actual time=0.009..0.009 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 - '31 days'::interval)))
  • -> Index Scan using notifications_summary_org_part_1_wl2_2019_w48_ntfn_id_idx on notifications_summary_org_part_1_wl2_2019_w48 (cost=0.14..3.17 rows=1 width=390) (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 - '31 days'::interval)))
  • -> Index Scan using notifications_summary_org_part_1_wl2_2019_w49_ntfn_id_idx on notifications_summary_org_part_1_wl2_2019_w49 (cost=0.14..3.17 rows=1 width=390) (actual time=0.008..0.008 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 - '31 days'::interval)))
  • -> Index Scan using notifications_summary_org_part_1_wl2_2019_w50_ntfn_id_idx on notifications_summary_org_part_1_wl2_2019_w50 (cost=0.14..3.17 rows=1 width=390) (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 - '31 days'::interval)))
  • -> Index Scan using notifications_summary_org_part_1_wl2_2019_w51_ntfn_id_idx on notifications_summary_org_part_1_wl2_2019_w51 (cost=0.14..3.17 rows=1 width=390) (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 - '31 days'::interval)))
  • -> Index Scan using notifications_summary_org_part_1_wl2_2019_w52_ntfn_id_idx on notifications_summary_org_part_1_wl2_2019_w52 (cost=0.14..3.17 rows=1 width=390) (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 - '31 days'::interval)))
Planning time : 834.966 ms
Execution time : 11.193 ms