explain.depesz.com

PostgreSQL's explain analyze made readable

Result: agu7

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.002 3.546 ↓ 0.0 0 1

Limit (cost=3,394.21..3,394.21 rows=1 width=271) (actual time=3.546..3.546 rows=0 loops=1)

2. 0.004 3.544 ↓ 0.0 0 1

Sort (cost=3,394.21..3,394.21 rows=1 width=271) (actual time=3.544..3.544 rows=0 loops=1)

  • Sort Key: press_posts.date DESC
  • Sort Method: quicksort Memory: 25kB
3. 0.001 3.540 ↓ 0.0 0 1

Nested Loop (cost=149.62..3,394.20 rows=1 width=271) (actual time=3.539..3.540 rows=0 loops=1)

  • Join Filter: (press_posts.press_id = presses.id)
4. 0.033 3.539 ↓ 0.0 0 1

Nested Loop (cost=149.62..3,379.42 rows=1 width=215) (actual time=3.539..3.539 rows=0 loops=1)

5. 2.959 3.506 ↓ 0.0 0 1

Bitmap Heap Scan on press_posts (cost=149.20..3,370.99 rows=1 width=215) (actual time=3.506..3.506 rows=0 loops=1)

  • Recheck Cond: (artist_id = ANY ('{d6a1c64b-9fa4-4611-ae31-8c1b2d093bc8,28a53892-95f1-497f-b2ac-1ac7361a8048,015ad8d8-9155-48eb-9cb9-106d31c34291,015b0fc5-92c2-4387-b8f5-667871383cc3,0d77ddf8-6b8f-41e8-8fe9-f63e77ccfbd8,1976764a-5afc-438e-9f63-a0b96cd22e0c,7a20d3c9-4141-4f53-870d-7d40ba6b8cdc,bb0a3e92-ae5c-4836-a46e-5f5c9a0da6bf,b2c1d91b-dbd5-4124-aa9e-0306a04cd69a,6972102f-1d22-4f29-95e7-0808d36d360f,57f834d6-48ec-4922-9819-c61e47579e06,0b704738-2fef-4847-aed8-33ac3f09786d,eefc9c88-1711-474b-ad8a-1ad493e30c40,80e50abc-bb29-450b-941c-cc50d958a9e0,3c8ce2cc-f522-4191-99a4-22f10fe8e755,adea487b-fb31-44de-8a73-fe9ec1e2fe1a,706b0b9d-c2f1-49d9-9f45-ee19c8bdd400,3bcac4a7-959a-4d22-b8b0-89d2e1d35621,22c40324-faad-42d7-af94-05e90a0d427a,8621bc45-35f4-40f6-88e9-9ae788b19fd9,b5cb2c2f-b1de-4dd5-846c-589db0535501,175b6686-c479-4ed7-aaf3-780b6370bd3d,9b0014ad-9ab0-4b40-b9e0-6547da88f9a8,8268de84-27ce-462f-a509-8042b1c02465,6c6a3ebd-24e4-4685-86d1-2399db7bbb14,919b9bca-b23a-4d53-99bd-be2e01e3cb1a,7e9efe7d-2947-4cf3-876d-9c5e4579de7b,132b225b-5389-463e-b046-e1741eaba247,0276dffe-094a-4e78-857a-c46fdb4ea810,1e89e122-804d-4451-a480-82aab0df0ede,f6bb38af-9a3e-4468-9a2a-6fd0e4aadf72,2cf1831e-8706-4df4-ba3d-2c9b3afbb3d0}'::uuid[]))
  • Filter: (in_title AND (date > '2019-08-01 01:01:00'::timestamp without time zone))
  • Rows Removed by Filter: 2837
  • Heap Blocks: exact=2329
6. 0.547 0.547 ↓ 2.8 2,837 1

Bitmap Index Scan on press_posts_artist_id_index (cost=0.00..149.20 rows=1,017 width=0) (actual time=0.547..0.547 rows=2,837 loops=1)

  • Index Cond: (artist_id = ANY ('{d6a1c64b-9fa4-4611-ae31-8c1b2d093bc8,28a53892-95f1-497f-b2ac-1ac7361a8048,015ad8d8-9155-48eb-9cb9-106d31c34291,015b0fc5-92c2-4387-b8f5-667871383cc3,0d77ddf8-6b8f-41e8-8fe9-f63e77ccfbd8,1976764a-5afc-438e-9f63-a0b96cd22e0c,7a20d3c9-4141-4f53-870d-7d40ba6b8cdc,bb0a3e92-ae5c-4836-a46e-5f5c9a0da6bf,b2c1d91b-dbd5-4124-aa9e-0306a04cd69a,6972102f-1d22-4f29-95e7-0808d36d360f,57f834d6-48ec-4922-9819-c61e47579e06,0b704738-2fef-4847-aed8-33ac3f09786d,eefc9c88-1711-474b-ad8a-1ad493e30c40,80e50abc-bb29-450b-941c-cc50d958a9e0,3c8ce2cc-f522-4191-99a4-22f10fe8e755,adea487b-fb31-44de-8a73-fe9ec1e2fe1a,706b0b9d-c2f1-49d9-9f45-ee19c8bdd400,3bcac4a7-959a-4d22-b8b0-89d2e1d35621,22c40324-faad-42d7-af94-05e90a0d427a,8621bc45-35f4-40f6-88e9-9ae788b19fd9,b5cb2c2f-b1de-4dd5-846c-589db0535501,175b6686-c479-4ed7-aaf3-780b6370bd3d,9b0014ad-9ab0-4b40-b9e0-6547da88f9a8,8268de84-27ce-462f-a509-8042b1c02465,6c6a3ebd-24e4-4685-86d1-2399db7bbb14,919b9bca-b23a-4d53-99bd-be2e01e3cb1a,7e9efe7d-2947-4cf3-876d-9c5e4579de7b,132b225b-5389-463e-b046-e1741eaba247,0276dffe-094a-4e78-857a-c46fdb4ea810,1e89e122-804d-4451-a480-82aab0df0ede,f6bb38af-9a3e-4468-9a2a-6fd0e4aadf72,2cf1831e-8706-4df4-ba3d-2c9b3afbb3d0}'::uuid[]))
7. 0.000 0.000 ↓ 0.0 0

Index Scan using artists_pkey on artists (cost=0.42..8.44 rows=1 width=32) (never executed)

  • Index Cond: (id = press_posts.artist_id)
8. 0.000 0.000 ↓ 0.0 0

Seq Scan on presses (cost=0.00..11.01 rows=301 width=72) (never executed)

Planning time : 6.480 ms
Execution time : 3.974 ms