explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FFFR

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 188,641.930 ↑ 1.0 8 1

Limit (cost=0.43..780.69 rows=8 width=80) (actual time=188,551.902..188,641.930 rows=8 loops=1)

2. 188,641.920 188,641.920 ↑ 1,527.1 8 1

Index Scan Backward using unitmessage_pkey on unitmessage (cost=0.43..1,191,547.46 rows=12,217 width=80) (actual time=188,551.900..188,641.920 rows=8 loops=1)

  • Filter: ((id)::text = '108'::text)