explain.depesz.com

PostgreSQL's explain analyze made readable

Result: i8qt

Settings
# exclusive inclusive rows x rows loops node
1. 1,126.059 2,129.626 ↓ 2.1 47,352 1

Unique (cost=0.42..30,319.57 rows=22,604 width=108) (actual time=0.050..2,129.626 rows=47,352 loops=1)

2. 1,003.567 1,003.567 ↓ 1.0 227,427 1

Index Scan Backward using pingdata_pkey on pingdata (cost=0.42..28,059.21 rows=226,036 width=108) (actual time=0.043..1,003.567 rows=227,427 loops=1)

Planning time : 0.199 ms
Execution time : 2,288.618 ms