explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nJHu

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

Update on notifications_summary (cost=0.28..6.88 rows=2 width=344) (actual time=0.096..0.096 rows=0 loops=1)

  • Update on notifications_summary_org_part_21_wl2_2019_w36
  • Update on notifications_summary_org_part_default
2. 0.040 0.040 ↑ 1.0 1 1

Index Scan using notifications_summary_org_part_21_wl2_2019_w36_created_date_idx on notifications_summary_org_part_21_wl2_2019_w36 (cost=0.28..3.31 rows=1 width=348) (actual time=0.039..0.040 rows=1 loops=1)

  • Index Cond: (created_date = '2019-09-05 06:15:13.533-07'::timestamp with time zone)
  • Filter: ((organization_uuid = 'dfeb21ad-74d5-4a30-991b-048636da8333'::uuid) AND (notification_uuid = 'a44109ae-796e-4d6b-b555-fe4717c597ac'::uuid))
3. 0.018 0.018 ↓ 0.0 0 1

Index Scan using notifications_summary_org_part_default_ntf_uuid_uidx on notifications_summary_org_part_default (cost=0.56..3.58 rows=1 width=341) (actual time=0.018..0.018 rows=0 loops=1)

  • Index Cond: ((organization_uuid = 'dfeb21ad-74d5-4a30-991b-048636da8333'::uuid) AND (notification_uuid = 'a44109ae-796e-4d6b-b555-fe4717c597ac'::uuid))
  • Filter: (created_date = '2019-09-05 06:15:13.533-07'::timestamp with time zone)
Planning time : 4,096.193 ms
Execution time : 0.485 ms