explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KQt5 : example55

Settings
# exclusive inclusive rows x rows loops node
1. 1.480 2,600.674 ↓ 0.0 0 1

Nested Loop (cost=0.23..1,822,644.45 rows=32 width=4) (actual time=2,600.674..2,600.674 rows=0 loops=1)

2. 2,594.888 2,594.888 ↓ 35.9 2,153 1

Index Scan using document_metadatas_updated_at_idx on document_metadatas (cost=0.11..1,822,505.10 rows=60 width=8) (actual time=112.500..2,594.888 rows=2,153 loops=1)

3. 4.306 4.306 ↓ 0.0 0 2,153

Index Scan using document_contents_pkey on document_contents (cost=0.11..2.32 rows=1 width=4) (actual time=0.002..0.002 rows=0 loops=2,153)