explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5O71

Settings
# exclusive inclusive rows x rows loops node
1. 294.522 349.264 ↓ 0.0 0 1

Update on issues (cost=1.19..180.75 rows=50 width=1,325) (actual time=349.264..349.264 rows=0 loops=1)

  • Buffers: shared hit=1,218 read=249 dirtied=130
  • I/O Timings: read=337.044
2.          

CTE cte

3. 0.096 0.096 ↑ 1.0 50 1

Values Scan on "*VALUES*" (cost=0.00..0.62 rows=50 width=8) (actual time=0.002..0.096 rows=50 loops=1)

4. 0.134 54.742 ↑ 3.3 15 1

Nested Loop (cost=0.56..180.13 rows=50 width=1,325) (actual time=8.100..54.742 rows=15 loops=1)

  • Buffers: shared hit=177 read=38
  • I/O Timings: read=53.820
5. 0.208 0.208 ↑ 1.0 50 1

CTE Scan on cte (cost=0.00..1.00 rows=50 width=40) (actual time=0.011..0.208 rows=50 loops=1)

6. 54.400 54.400 ↓ 0.0 0 50

Index Scan using issues_pkey on issues (cost=0.56..3.58 rows=1 width=1,261) (actual time=1.088..1.088 rows=0 loops=50)

  • Index Cond: (id = cte.cte_id)
  • Buffers: shared hit=177 read=38
  • I/O Timings: read=53.820
Planning time : 0.517 ms
Execution time : 349.414 ms