explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Cwwi : Optimization for: Optimization for: plan #WwJ2; plan #Dviu

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.000 357.712 ↑ 1.0 1 1

Finalize Aggregate (cost=64,421.24..64,421.25 rows=1 width=4) (actual time=357.712..357.712 rows=1 loops=1)

2. 77.051 402.089 ↓ 1.5 3 1

Gather (cost=64,421.03..64,421.24 rows=2 width=8) (actual time=355.000..402.089 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.004 325.038 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=63,421.03..63,421.04 rows=1 width=8) (actual time=325.038..325.038 rows=1 loops=3)

4. 121.538 325.034 ↓ 0.0 0 3 / 3

Parallel Hash Left Join (cost=29,799.60..63,421.01 rows=8 width=0) (actual time=312.579..325.034 rows=0 loops=3)

  • Hash Cond: (t."ID" = t0."TicketID")
  • Filter: ((t."AgentPersonID" = '2f9d398a-7847-11ea-bce8-56fc329cd4d1'::uuid) OR (t0."ExcavatorContactID" = 'ea56d556-1504-e311-aac5-000c2904053c'::uuid))
  • Rows Removed by Filter: 25,628
5. 15.569 17.158 ↑ 1.3 25,629 3 / 3

Parallel Bitmap Heap Scan on "Tickets" t (cost=1,645.05..33,092.91 rows=32,207 width=32) (actual time=5.300..17.158 rows=25,629 loops=3)

  • Recheck Cond: (("TakenEndDate" >= '2020-05-31 00:00:00-04'::timestamp with time zone) AND ("TakenEndDate" < '2020-07-01 00:00:00-04'::timestamp with time zone))
  • Filter: (("TicketTypeID" <> '9084e88d-25bb-4f8a-9a2a-9a0801136044'::uuid) OR ("TicketTypeID" IS NULL))
  • Rows Removed by Filter: 7
  • Heap Blocks: exact=2,069
6. 1.589 1.589 ↑ 1.0 76,906 1 / 3

Bitmap Index Scan on "IX_Tickets_TakenEndDate" (cost=0.00..1,625.73 rows=77,330 width=0) (actual time=4.767..4.767 rows=76,906 loops=1)

  • Index Cond: (("TakenEndDate" >= '2020-05-31 00:00:00-04'::timestamp with time zone) AND ("TakenEndDate" < '2020-07-01 00:00:00-04'::timestamp with time zone))
7. 97.612 186.338 ↑ 1.3 192,695 3 / 3

Parallel Hash (cost=23,496.69..23,496.69 rows=240,869 width=32) (actual time=186.338..186.338 rows=192,695 loops=3)

  • Buckets: 65,536 Batches: 16 Memory Usage: 2,816kB
8. 88.726 88.726 ↑ 1.3 192,695 3 / 3

Parallel Seq Scan on "TicketExcavators" t0 (cost=0.00..23,496.69 rows=240,869 width=32) (actual time=0.090..88.726 rows=192,695 loops=3)

Planning time : 0.777 ms
Execution time : 402.187 ms