explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8nKF

Settings
# exclusive inclusive rows x rows loops node
1. 2.753 1,131.228 ↑ 1.1 19,543 1

Result (cost=0.69..14,855.51 rows=21,920 width=48) (actual time=1.272..1,131.228 rows=19,543 loops=1)

2. 1,128.475 1,128.475 ↑ 1.1 19,543 1

Unique (cost=0.69..14,855.51 rows=21,920 width=48) (actual time=1.272..1,128.475 rows=19,543 loops=1)

  • -> Index Only Scan using imports_unique_pkey on imports_unique (cost=0.69..14795.64 rows=23,947 width=48) (act
  • Index Cond: (to_path = 'github.com/aws/aws-sdk-go/aws'::text)
  • Filter: (from_module_path <> 'github.com/aws/aws-sdk-go/aws'::text)
  • Heap Fetches: 2,077