explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3cRB

Settings
# exclusive inclusive rows x rows loops node
1. 55.583 979.473 ↓ 0.0 0 1

Update on virtual_browser (cost=3,728.72..46,348.15 rows=5,000 width=741) (actual time=979.473..979.473 rows=0 loops=1)

2.          

CTE retires

3. 0.036 877.971 ↑ 32.9 152 1

Limit (cost=0.57..3,728.15 rows=5,000 width=16) (actual time=876.681..877.971 rows=152 loops=1)

4. 877.935 877.935 ↑ 13,211.2 152 1

Index Only Scan using virtual_browser_new_retire on virtual_browser virtual_browser_1 (cost=0.57..1,497,074.47 rows=2,008,101 width=16) (actual time=876.681..877.935 rows=152 loops=1)

  • Index Cond: (created < (now() - '30 days'::interval))
  • Filter: (state <> 'retired'::virtual_browser_state)
  • Rows Removed by Filter: 2,323,450
  • Heap Fetches: 392,417
5. 0.277 923.890 ↑ 32.9 152 1

Nested Loop (cost=0.56..42,620.00 rows=5,000 width=741) (actual time=877.095..923.890 rows=152 loops=1)

6. 878.165 878.165 ↑ 32.9 152 1

CTE Scan on retires (cost=0.00..100.00 rows=5,000 width=56) (actual time=876.689..878.165 rows=152 loops=1)

7. 45.448 45.448 ↑ 1.0 1 152

Index Scan using virtual_browser_new_pkey on virtual_browser (cost=0.56..8.50 rows=1 width=697) (actual time=0.299..0.299 rows=1 loops=152)

  • Index Cond: (virtual_browser_id = retires.virtual_browser_id)
Planning time : 0.386 ms
Execution time : 979.516 ms