explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Jcc8

Settings
# exclusive inclusive rows x rows loops node
1. 0.108 106.466 ↑ 4.7 35 1

Sort (cost=157,888.76..157,888.84 rows=166 width=211) (actual time=106.462..106.466 rows=35 loops=1)

  • Sort Key: a0.inserted_at DESC
  • Sort Method: quicksort Memory: 34kB
2. 35.938 106.358 ↑ 4.7 35 1

Seq Scan on addresses a0 (cost=0.00..157,887.53 rows=166 width=211) (actual time=4.621..106.358 rows=35 loops=1)

  • Filter: (to_tsvector('simple'::regconfig, (street_address)::text) @@ to_tsquery('simple'::regconfig, concat('''''''22'''''''::text, ':*')))
  • Rows Removed by Filter: 8251
3.          

SubPlan (forSeq Scan)

4. 0.070 41.090 ↑ 1.0 1 35

Aggregate (cost=788.25..788.25 rows=1 width=8) (actual time=1.174..1.174 rows=1 loops=35)

5. 41.020 41.020 ↓ 0.0 0 35

Seq Scan on bills b (cost=0.00..788.25 rows=1 width=4) (actual time=1.137..1.172 rows=0 loops=35)

  • Filter: (address_id = a0.id)
  • Rows Removed by Filter: 7312
6. 0.070 29.330 ↑ 1.0 1 35

Aggregate (cost=155.66..155.66 rows=1 width=8) (actual time=0.838..0.838 rows=1 loops=35)

7. 29.260 29.260 ↓ 0.0 0 35

Seq Scan on transactions t (cost=0.00..155.66 rows=1 width=4) (actual time=0.798..0.836 rows=0 loops=35)

  • Filter: ((address_id = a0.id) AND (status = 'paid'::transaction_status))
  • Rows Removed by Filter: 5925