explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X79g

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.022 ↑ 1.0 1 1

Limit (cost=0.12..8.22 rows=1 width=811) (actual time=0.022..0.022 rows=1 loops=1)

2. 0.000 0.021 ↑ 2.0 1 1

Append (cost=0.12..16.32 rows=2 width=811) (actual time=0.021..0.021 rows=1 loops=1)

3. 0.011 0.011 ↓ 0.0 0 1

Index Scan using executions_uuid_key on executions (cost=0.12..8.15 rows=1 width=294) (actual time=0.010..0.011 rows=0 loops=1)

  • Index Cond: (uuid = '42bce4ed-4e87-48e7-bb22-26911b24bc2c'::uuid)
  • Filter: ((started_at >= '2019-08-05 00:00:00'::timestamp without time zone) AND (started_at <= '2019-08-05 23:59:59'::timestamp without time zone) AND (company_uuid = 'b7fa583e-a144-4ec2-9464-e1e514512fb4'::uuid) AND (activity_type_id = 1))
4. 0.010 0.010 ↑ 1.0 1 1

Index Scan using executions_b7fa583e_201908_uuid_key on executions_b7fa583e_201908 (cost=0.14..8.17 rows=1 width=1,330) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (uuid = '42bce4ed-4e87-48e7-bb22-26911b24bc2c'::uuid)
  • Filter: ((started_at >= '2019-08-05 00:00:00'::timestamp without time zone) AND (started_at <= '2019-08-05 23:59:59'::timestamp without time zone) AND (company_uuid = 'b7fa583e-a144-4ec2-9464-e1e514512fb4'::uuid) AND (activity_type_id = 1))
Planning time : 3.983 ms
Execution time : 0.064 ms