explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AiuO : 123

Settings
# exclusive inclusive rows x rows loops node
1. 0.020 0.100 ↑ 5.8 12 1

Hash Left Join (cost=3.68..147.22 rows=70 width=1,674) (actual time=0.062..0.100 rows=12 loops=1)

  • Hash Cond: (this_.payeestateid = state2_.stateid)
2. 0.038 0.038 ↑ 5.8 12 1

Index Scan using idx_payment_customerid on fs_payment this_ (cost=0.45..143.02 rows=70 width=1,612) (actual time=0.012..0.038 rows=12 loops=1)

  • Index Cond: ((customerid = ANY ('{127213,127215,127268,127328,127358,127364,127527,127560,127616,127661}'::bigint[])) AND (customerid IS NOT NULL))
  • Filter: (paiddate IS NULL)
  • Rows Removed by Filter: 1
3. 0.042 0.042 ↑ 1.0 55 1

Hash (cost=2.55..2.55 rows=55 width=62) (actual time=0.042..0.042 rows=55 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 6kB
  • -> Seq Scan on ref_state state2_ (cost=0.00..2.55 rows=55 width=62) (actual time=0.003..0.017 rows=55 loops=1)"Total runtime: 0.153 ms