explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AwQL : example44

Settings
# exclusive inclusive rows x rows loops node
1. 1.577 7.328 ↓ 0.0 0 1

Nested Loop (cost=0.28..3,786.34 rows=32 width=4) (actual time=7.328..7.328 rows=0 loops=1)

2. 1.445 1.445 ↓ 35.9 2,153 1

Index Scan using document_metadatas_unique_patient_to_document_id_uniq on document_metadatas (cost=0.16..3,646.99 rows=60 width=8) (actual time=0.031..1.445 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)