explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z8xZ

Settings
# exclusive inclusive rows x rows loops node
1. 19,121.091 3,714,062.772 ↑ 5,215,881.2 5 1

GroupAggregate (cost=0.56..4,806,076.09 rows=26,079,406 width=16) (actual time=3,626,533.276..3,714,062.772 rows=5 loops=1)

  • Group Key: udprn
  • Filter: (count(*) > 1)
  • Rows Removed by Filter: 26079396
2. 3,694,941.681 3,694,941.681 ↑ 1.0 26,079,406 1

Index Only Scan using idx_postal_address_s2_udprn on postal_address_s2 pas (cost=0.56..4,349,686.49 rows=26,079,406 width=8) (actual time=0.110..3,694,941.681 rows=26,079,406 loops=1)

  • Heap Fetches: 26079406
Planning time : 0.068 ms