explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LL0Z

Settings
# exclusive inclusive rows x rows loops node
1. 8.121 42.159 ↑ 1.0 1 1

Aggregate (cost=2,214.18..2,214.19 rows=1 width=8) (actual time=42.159..42.159 rows=1 loops=1)

2. 34.038 34.038 ↓ 1.0 109,329 1

Index Only Scan using transcripts_pkey on transcripts (cost=0.29..1,945.21 rows=107,588 width=0) (actual time=0.096..34.038 rows=109,329 loops=1)

  • Heap Fetches: 743
Planning time : 0.583 ms
Execution time : 42.198 ms