explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oAUY

Settings
# exclusive inclusive rows x rows loops node
1. 0.053 1.043 ↑ 69.3 200 1

Nested Loop (cost=10.49..857.57 rows=13,870 width=548) (actual time=0.115..1.043 rows=200 loops=1)

2. 0.151 0.190 ↓ 2.0 200 1

HashAggregate (cost=10.07..11.07 rows=100 width=4) (actual time=0.085..0.190 rows=200 loops=1)

  • Group Key: unnest(client_logs.change_ids)
3. 0.024 0.039 ↓ 2.0 200 1

ProjectSet (cost=0.29..8.82 rows=100 width=4) (actual time=0.017..0.039 rows=200 loops=1)

4. 0.015 0.015 ↑ 1.0 1 1

Index Scan using client_logs_client_id_by_date_index on client_logs (cost=0.29..8.31 rows=1 width=826) (actual time=0.014..0.015 rows=1 loops=1)

  • Index Cond: ((client_id = 2962) AND (change_date > '2018-07-01'::date) AND (change_date < '2018-07-07'::date))
5. 0.200 0.800 ↑ 1.0 1 200

Append (cost=0.43..8.46 rows=1 width=548) (actual time=0.003..0.004 rows=1 loops=200)

6. 0.600 0.600 ↑ 1.0 1 200

Index Scan using changes_y2018_change_id_change_date_idx on changes_y2018 (cost=0.43..8.45 rows=1 width=548) (actual time=0.003..0.003 rows=1 loops=200)

  • Index Cond: ((change_id = (unnest(client_logs.change_ids))) AND (change_date > '2018-07-01'::date) AND (change_date < '2018-07-07'::date))