explain.depesz.com

PostgreSQL's explain analyze made readable

Result: p4bQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.418 ↑ 4.3 26 1

Append (cost=0.43..275.49 rows=113 width=213) (actual time=0.300..0.418 rows=26 loops=1)

  • Subplans Removed: 47
2. 0.004 0.055 ↓ 0.0 0 1

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

  • 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.051 0.051 ↓ 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.051..0.051 rows=0 loops=1)

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

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

  • 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.030 0.030 ↓ 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.030..0.030 rows=0 loops=1)

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

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

  • 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.028 0.028 ↓ 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.028..0.028 rows=0 loops=1)

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

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

  • 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.035 0.035 ↓ 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.035..0.035 rows=0 loops=1)

  • Index Cond: (event_uuid = '48095733-c47a-4d09-9c13-56ccea84ac24'::uuid)
10. 0.116 0.190 ↑ 1.0 26 1

Bitmap Heap Scan on notifications_summary_org_part_23_wl2_2019_w36 (cost=1.99..35.89 rows=26 width=188) (actual time=0.119..0.190 rows=26 loops=1)

  • 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)))
  • Heap Blocks: exact=7
11. 0.074 0.074 ↓ 2.1 55 1

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 time=0.074..0.074 rows=55 loops=1)

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

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 time=0.044..0.044 rows=0 loops=1)

  • 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)))
Planning time : 29,401.287 ms
Execution time : 1.747 ms