explain.depesz.com

PostgreSQL's explain analyze made readable

Result: S4qj

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

Update on workflow_details (cost=15.29..16.61 rows=1 width=137) (actual time=0.586..0.586 rows=0 loops=1)

2. 0.018 0.266 ↑ 1.0 1 1

Bitmap Heap Scan on workflow_details (cost=15.29..16.61 rows=1 width=137) (actual time=0.265..0.266 rows=1 loops=1)

  • Recheck Cond: ((workflow_uuid = '8bb2f9de-2e0d-4d7c-bb97-a11fdf3df0b5'::uuid) AND (contractor_uuid = '0ba851cb-641b-4c12-b9eb-5de426bff6ac'::uuid))
  • Filter: (workflow_label <> 'B2G_REPORT_ARCHIVE'::workflow_label)
  • Heap Blocks: exact=1
3. 0.003 0.248 ↓ 0.0 0 1

BitmapAnd (cost=15.29..15.29 rows=1 width=0) (actual time=0.248..0.248 rows=0 loops=1)

4. 0.041 0.041 ↑ 9.8 6 1

Bitmap Index Scan on workflow_person_details_workflow_uuid_idx (cost=0.00..2.17 rows=59 width=0) (actual time=0.041..0.041 rows=6 loops=1)

  • Index Cond: (workflow_uuid = '8bb2f9de-2e0d-4d7c-bb97-a11fdf3df0b5'::uuid)
5. 0.204 0.204 ↓ 1.5 1,451 1

Bitmap Index Scan on workflow_details_contractor_uuid_idx (cost=0.00..12.87 rows=965 width=0) (actual time=0.204..0.204 rows=1,451 loops=1)

  • Index Cond: (contractor_uuid = '0ba851cb-641b-4c12-b9eb-5de426bff6ac'::uuid)
Planning time : 0.207 ms
Execution time : 3,520.064 ms
Trigger times:
Trigger Name:Total time:Calls:Average time:
sync_b2g_header_on_workflow_details_change 3,519.058 ms 1 3,519.058 ms
version_inc 0.132 ms 1 0.132 ms