explain.depesz.com

PostgreSQL's explain analyze made readable

Result: z8lE

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.341 ↑ 1.0 10 1

Limit (cost=46,246.71..46,246.74 rows=10 width=548) (actual time=0.337..0.341 rows=10 loops=1)

2. 0.012 0.337 ↑ 213,221.4 10 1

Sort (cost=46,246.71..51,577.25 rows=2,132,214 width=548) (actual time=0.336..0.337 rows=10 loops=1)

  • Sort Key: changes_y2018.change_date DESC
  • Sort Method: quicksort Memory: 30kB
3. 0.006 0.325 ↑ 213,221.4 10 1

Nested Loop (cost=1.43..170.33 rows=2,132,214 width=548) (actual time=0.164..0.325 rows=10 loops=1)

4. 0.010 0.119 ↑ 1.0 10 1

HashAggregate (cost=1.01..1.11 rows=10 width=4) (actual time=0.115..0.119 rows=10 loops=1)

  • Group Key: (unnest(patient_logs.change_ids))
5. 0.003 0.109 ↑ 1.0 10 1

Limit (cost=0.43..0.88 rows=10 width=8) (actual time=0.048..0.109 rows=10 loops=1)

6. 0.009 0.106 ↑ 1,880.0 10 1

ProjectSet (cost=0.43..855.12 rows=18,800 width=8) (actual time=0.048..0.106 rows=10 loops=1)

7. 0.097 0.097 ↑ 20.9 9 1

Index Scan Backward using patient_logs_patient_id_change_date_key on patient_logs (cost=0.43..759.71 rows=188 width=29) (actual time=0.045..0.097 rows=9 loops=1)

  • Index Cond: (patient_id = 386)
8. 0.010 0.200 ↑ 2.0 1 10

Append (cost=0.43..16.90 rows=2 width=548) (actual time=0.019..0.020 rows=1 loops=10)

9. 0.040 0.040 ↓ 0.0 0 10

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.004..0.004 rows=0 loops=10)

  • Index Cond: (change_id = (unnest(patient_logs.change_ids)))
10. 0.150 0.150 ↑ 1.0 1 10

Index Scan using changes_y2019_change_id_change_date_idx on changes_y2019 (cost=0.43..8.45 rows=1 width=548) (actual time=0.015..0.015 rows=1 loops=10)

  • Index Cond: (change_id = (unnest(patient_logs.change_ids)))