explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dVYVj

Settings
# exclusive inclusive rows x rows loops node
1. 2.144 55,239.025 ↓ 0.0 0 1

Gather (cost=1,000.00..330,109.22 rows=1 width=89) (actual time=55,239.025..55,239.025 rows=0 loops=1)

  • Workers Planned: 5
  • Workers Launched: 0
2. 55,236.881 55,236.881 ↓ 0.0 0 1

Parallel Seq Scan on contributions_addresses (cost=0.00..329,109.12 rows=1 width=89) (actual time=55,236.881..55,236.881 rows=0 loops=1)

  • Filter: ((city ~~* 'DENVER'::citext) AND (state ~~* 'CO'::citext) AND (address ~~* '7170 E PRINCETON AVE'::citext) AND (zip ~~* '80237-2072'::citext) AND (id <> 237951684))
  • Rows Removed by Filter: 22660157
Planning time : 0.843 ms
Execution time : 55,240.300 ms