explain.depesz.com

PostgreSQL's explain analyze made readable

Result: I3DAM

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 8.457 ↑ 1.0 10 1

Limit (cost=0.44..53.46 rows=10 width=33) (actual time=4.410..8.457 rows=10 loops=1)

2. 0.089 8.454 ↑ 21,703.4 10 1

Nested Loop (cost=0.44..1,150,748.61 rows=217,034 width=33) (actual time=4.410..8.454 rows=10 loops=1)

3. 0.643 0.643 ↑ 13,182.9 1,287 1

Index Scan Backward using service_discover_time on service s (cost=0.44..672,172.55 rows=16,966,402 width=33) (actual time=0.067..0.643 rows=1,287 loops=1)

4. 7.722 7.722 ↓ 0.0 0 1,287

Index Scan using idx_pddocument on pddocument pdf (cost=0.00..0.02 rows=1 width=25) (actual time=0.006..0.006 rows=0 loops=1,287)

  • Index Cond: (blob = s.blob)