explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8cj

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.208 ↓ 0.0 0 1

Nested Loop (cost=0.85..6,820.11 rows=35,171,078 width=663) (actual time=0.208..0.208 rows=0 loops=1)

2. 0.000 0.207 ↓ 0.0 0 1

Subquery Scan on ANY_subquery (cost=0.42..46.86 rows=100 width=8) (actual time=0.207..0.207 rows=0 loops=1)

3. 0.061 0.207 ↓ 0.0 0 1

HashSetOp Intersect (cost=0.42..45.86 rows=100 width=12) (actual time=0.207..0.207 rows=0 loops=1)

4. 0.024 0.146 ↑ 1.5 392 1

Append (cost=0.42..44.36 rows=600 width=12) (actual time=0.020..0.146 rows=392 loops=1)

5. 0.034 0.105 ↓ 3.9 392 1

Subquery Scan on *SELECT* 1 (cost=0.42..10.45 rows=100 width=12) (actual time=0.020..0.105 rows=392 loops=1)

6. 0.023 0.071 ↓ 3.9 392 1

Append (cost=0.42..9.45 rows=100 width=8) (actual time=0.019..0.071 rows=392 loops=1)

7. 0.036 0.048 ↓ 3.9 392 1

ProjectSet (cost=0.42..8.95 rows=100 width=8) (actual time=0.018..0.048 rows=392 loops=1)

8. 0.012 0.012 ↑ 1.0 1 1

Index Scan using client_logs_y2018_client_id_change_date_idx on client_logs_y2018 (cost=0.42..8.44 rows=1 width=652) (actual time=0.010..0.012 rows=1 loops=1)

  • Index Cond: ((client_id = 6219) AND (change_date = '2018-12-11'::date))
9. 0.000 0.017 ↓ 0.0 0 1

Subquery Scan on *SELECT* 2 (cost=4.17..30.92 rows=500 width=12) (actual time=0.017..0.017 rows=0 loops=1)

10. 0.001 0.017 ↓ 0.0 0 1

Append (cost=4.17..25.92 rows=500 width=8) (actual time=0.017..0.017 rows=0 loops=1)

11. 0.000 0.004 ↓ 0.0 0 1

ProjectSet (cost=4.17..12.80 rows=300 width=8) (actual time=0.004..0.004 rows=0 loops=1)

12. 0.001 0.004 ↓ 0.0 0 1

Bitmap Heap Scan on drawing_viewer_list_logs_y2013 (cost=4.17..11.28 rows=3 width=34) (actual time=0.004..0.004 rows=0 loops=1)

  • Recheck Cond: (osteopath_id = 6219)
13. 0.003 0.003 ↓ 0.0 0 1

Bitmap Index Scan on drawing_viewer_list_logs_y2013_osteopath_id_change_date_idx (cost=0.00..4.17 rows=3 width=0) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (osteopath_id = 6219)
14. 0.001 0.010 ↓ 0.0 0 1

ProjectSet (cost=0.00..1.94 rows=100 width=8) (actual time=0.009..0.010 rows=0 loops=1)

15. 0.009 0.009 ↓ 0.0 0 1

Seq Scan on drawing_viewer_list_logs_y2018 (cost=0.00..1.44 rows=1 width=34) (actual time=0.009..0.009 rows=0 loops=1)

  • Filter: (osteopath_id = 6219)
  • Rows Removed by Filter: 37
16. 0.000 0.002 ↓ 0.0 0 1

ProjectSet (cost=0.14..8.67 rows=100 width=8) (actual time=0.002..0.002 rows=0 loops=1)

17. 0.002 0.002 ↓ 0.0 0 1

Index Scan using drawing_viewer_list_logs_y2019_osteopath_id_change_date_idx on drawing_viewer_list_logs_y2019 (cost=0.14..8.16 rows=1 width=34) (actual time=0.002..0.002 rows=0 loops=1)

  • Index Cond: (osteopath_id = 6219)
18. 0.000 0.000 ↓ 0.0 0

Append (cost=0.43..67.65 rows=8 width=663) (never executed)

19. 0.000 0.000 ↓ 0.0 0

Index Scan using changes_0ml_change_id_idx on changes_0ml (cost=0.43..8.45 rows=1 width=674) (never executed)

  • Index Cond: (change_id = "ANY_subquery".unnest)
20. 0.000 0.000 ↓ 0.0 0

Index Scan using changes_1mi_change_id_idx on changes_1mi (cost=0.43..8.45 rows=1 width=663) (never executed)

  • Index Cond: (change_id = "ANY_subquery".unnest)
21. 0.000 0.000 ↓ 0.0 0

Index Scan using changes_2mi_change_id_idx on changes_2mi (cost=0.43..8.45 rows=1 width=664) (never executed)

  • Index Cond: (change_id = "ANY_subquery".unnest)
22. 0.000 0.000 ↓ 0.0 0

Index Scan using changes_3mi_change_id_idx on changes_3mi (cost=0.43..8.45 rows=1 width=661) (never executed)

  • Index Cond: (change_id = "ANY_subquery".unnest)
23. 0.000 0.000 ↓ 0.0 0

Index Scan using changes_4mi_change_id_idx on changes_4mi (cost=0.43..8.45 rows=1 width=663) (never executed)

  • Index Cond: (change_id = "ANY_subquery".unnest)
24. 0.000 0.000 ↓ 0.0 0

Index Scan using changes_5mi_change_id_idx on changes_5mi (cost=0.43..8.45 rows=1 width=660) (never executed)

  • Index Cond: (change_id = "ANY_subquery".unnest)
25. 0.000 0.000 ↓ 0.0 0

Index Scan using changes_6mi_change_id_idx on changes_6mi (cost=0.43..8.45 rows=1 width=670) (never executed)

  • Index Cond: (change_id = "ANY_subquery".unnest)
26. 0.000 0.000 ↓ 0.0 0

Index Scan using changes_7mi_change_id_idx on changes_7mi (cost=0.43..8.45 rows=1 width=575) (never executed)

  • Index Cond: (change_id = "ANY_subquery".unnest)
Planning time : 0.614 ms
Execution time : 0.320 ms