explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YD2Q

Settings
# exclusive inclusive rows x rows loops node
1. 10,963.905 18,061.906 ↑ 47.3 955 1

Result (cost=0.42..2,409,734.28 rows=45,190 width=191) (actual time=28.396..18,061.906 rows=955 loops=1)

2. 3,100.057 7,098.001 ↑ 47.3 955 1

ProjectSet (cost=0.42..2,397,532.98 rows=45,190 width=159) (actual time=15.166..7,098.001 rows=955 loops=1)

3. 9.105 3,997.944 ↓ 1.1 5,148 1

Nested Loop (cost=0.42..2,397,250.54 rows=4,519 width=822) (actual time=8.100..3,997.944 rows=5,148 loops=1)

4. 3,968.247 3,968.247 ↓ 1.1 5,148 1

Seq Scan on transfers t (cost=0.00..2,386,562.98 rows=4,519 width=813) (actual time=8.084..3,968.247 rows=5,148 loops=1)

  • Filter: ((state = 'UNKNOWN'::creation_state) AND (created_at < (CURRENT_TIMESTAMP - '00:05:00'::interval minute)))
  • Rows Removed by Filter: 13,549,030
5. 20.592 20.592 ↑ 1.0 1 5,148

Index Scan using merchants_pkey on merchants m (cost=0.42..2.37 rows=1 width=25) (actual time=0.004..0.004 rows=1 loops=5,148)

  • Index Cond: (id = t.merchant_id) | Planning time: 0.286 ms |