explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6GEN

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

Append (cost=0.43..275.47 rows=113 width=213) (actual rows= loops=)

  • Subplans Removed: 47
2. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w32 (cost=2.01..19.95 rows=3 width=177) (actual rows= loops=)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: ((organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid) AND (created_date <= CURRENT_TIMESTAMP) AND (created_date >= (CURRENT_TIMESTAMP - '31 days'::interval)))
3. 0.000 0.000 ↓ 0.0

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

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

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w33 (cost=1.98..15.35 rows=9 width=186) (actual rows= loops=)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: ((organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid) AND (created_date <= CURRENT_TIMESTAMP) AND (created_date >= (CURRENT_TIMESTAMP - '31 days'::interval)))
5. 0.000 0.000 ↓ 0.0

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

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

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w34 (cost=2.01..19.93 rows=12 width=187) (actual rows= loops=)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: ((organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid) AND (created_date <= CURRENT_TIMESTAMP) AND (created_date >= (CURRENT_TIMESTAMP - '31 days'::interval)))
7. 0.000 0.000 ↓ 0.0

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

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

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w35 (cost=2.04..24.44 rows=15 width=187) (actual rows= loops=)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: ((organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid) AND (created_date <= CURRENT_TIMESTAMP) AND (created_date >= (CURRENT_TIMESTAMP - '31 days'::interval)))
9. 0.000 0.000 ↓ 0.0

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

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

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w36 (cost=1.99..35.87 rows=26 width=188) (actual rows= loops=)

  • Recheck Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: ((organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid) AND (created_date <= CURRENT_TIMESTAMP) AND (created_date >= (CURRENT_TIMESTAMP - '31 days'::interval)))
11. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on notifications_summary_org_part_23_wl2_2019_w36_event_uuid_idx (cost=0.00..1.98 rows=26 width=0) (actual rows= loops=)

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

Index Scan using notifications_summary_org_part_23_wl2_2019_w37_event_uuid_idx on notifications_summary_org_part_23_wl2_2019_w37 (cost=0.14..3.18 rows=1 width=390) (actual rows= loops=)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
  • Filter: ((organization_uuid = '6055c03b-4741-4842-905a-88b004d94df8'::uuid) AND (created_date <= CURRENT_TIMESTAMP) AND (created_date >= (CURRENT_TIMESTAMP - '31 days'::interval)))