explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SAGO

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

Append (cost=0.43..129.80 rows=54 width=241) (actual rows= loops=)

  • Subplans Removed: 47
2. 0.000 0.000 ↓ 0.0

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 rows= loops=)

  • 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)))
3. 0.000 0.000 ↓ 0.0

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 rows= loops=)

  • 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)))
4. 0.000 0.000 ↓ 0.0

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 rows= loops=)

  • 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)))
5. 0.000 0.000 ↓ 0.0

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 rows= loops=)

  • 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)))
6. 0.000 0.000 ↓ 0.0

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 rows= loops=)

  • 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)))
7. 0.000 0.000 ↓ 0.0

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 rows= loops=)

  • 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)))