explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MLbd

Settings
# exclusive inclusive rows x rows loops node
1. 0.371 2,397.889 ↑ 3,276.0 48 1

Hash Join (cost=12.80..179,286.84 rows=157,246 width=446) (actual time=159.679..2,397.889 rows=48 loops=1)

  • Hash Cond: (tpi_tradingaccount.backend_id = tpi_tradingbackend.id)
2. 2,397.317 2,397.317 ↑ 3,276.0 48 1

Seq Scan on tpi_tradingaccount (cost=0.00..177,111.91 rows=157,246 width=446) (actual time=159.390..2,397.317 rows=48 loops=1)

  • Filter: ((expired_at IS NULL) AND (expires_at <= '2019-07-09 11:00:45.713158-04'::timestamp with time zone) AND (status = 1))
  • Rows Removed by Filter: 2356943
3. 0.035 0.201 ↑ 1.0 32 1

Hash (cost=12.40..12.40 rows=32 width=4) (actual time=0.201..0.201 rows=32 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
4. 0.166 0.166 ↑ 1.0 32 1

Seq Scan on tpi_tradingbackend (cost=0.00..12.40 rows=32 width=4) (actual time=0.029..0.166 rows=32 loops=1)

  • Filter: (mode = ANY ('{0,1}'::integer[]))
Planning time : 4.473 ms
Execution time : 2,398.103 ms