explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mzXq

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 26,479.794 ↓ 0.0 0 1

Nested Loop (cost=406.12..27,666.01 rows=1 width=498) (actual time=26,479.794..26,479.794 rows=0 loops=1)

2. 24,128.070 26,479.792 ↓ 0.0 0 1

Bitmap Heap Scan on occurrence occurrence0_ (cost=405.98..27,661.66 rows=1 width=498) (actual time=26,479.792..26,479.792 rows=0 loops=1)

  • Recheck Cond: (user_uuid = '3251a8f6-c11b-4783-aba7-f7718bd9371f'::uuid)
  • Filter: ((occurrence_state)::text = ANY ('{ALLOCATED,CONCLUDING}'::text[]))
  • Rows Removed by Filter: 6,400
  • Heap Blocks: exact=6,421
3. 2,351.722 2,351.722 ↑ 2.0 6,522 1

Bitmap Index Scan on idx_occurrence_user_uuuid (cost=0.00..405.98 rows=13,255 width=0) (actual time=2,351.722..2,351.722 rows=6,522 loops=1)

  • Index Cond: (user_uuid = '3251a8f6-c11b-4783-aba7-f7718bd9371f'::uuid)
4. 0.000 0.000 ↓ 0.0 0

Index Only Scan using pk_users on users user1_ (cost=0.14..4.25 rows=1 width=16) (never executed)

  • Index Cond: (uuid = '3251a8f6-c11b-4783-aba7-f7718bd9371f'::uuid)
  • Heap Fetches: 0
Planning time : 0.633 ms
Execution time : 26,479.837 ms