explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9R5K

Settings
# exclusive inclusive rows x rows loops node
1. 1.889 13.838 ↑ 1.1 19,543 1

Result (cost=0.69..14,795.64 rows=21,920 width=48) (actual time=0.049..13.838 rows=19,543 loops=1)

2. 11.949 11.949 ↑ 1.1 19,543 1

Unique (cost=0.69..14,795.64 rows=21,920 width=48) (actual time=0.047..11.949 rows=19,543 loops=1)

  • -> Index Only Scan using imports_unique_pkey on imports_unique (cost=0.69..14735.77 rows=23,948 width=48) (actual tim
  • Index Cond: (to_path = 'github.com/aws/aws-sdk-go/aws'::text)
  • Heap Fetches: 1,550
Planning time : 0.112 ms
Execution time : 14.633 ms