explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AY52

Settings
# exclusive inclusive rows x rows loops node
1. 0.044 1.100 ↑ 65.0 200 1
→

Nested Loop (cost=10.49..857.57 rows=12,999 width=548) (actual time=0.162..1.100 rows=200 loops=1)

2. 0.192 0.256 ↓ 2.0 200 1
→

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

  • Group Key: unnest(client_logs.change_ids)
3. 0.030 0.064 ↓ 2.0 200 1
→

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

4. 0.034 0.034 ↑ 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.033..0.034 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))