explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SsRP

Settings
# exclusive inclusive rows x rows loops node
1. 5.279 942.896 ↓ 0.0 0 1

Delete on members (cost=281.99..3,734.55 rows=1,000 width=34) (actual time=942.896..942.896 rows=0 loops=1)

2. 1.533 937.617 ↑ 1.0 1,000 1

Nested Loop (cost=281.99..3,734.55 rows=1,000 width=34) (actual time=685.494..937.617 rows=1,000 loops=1)

3. 2.552 684.084 ↑ 1.0 1,000 1

HashAggregate (cost=281.55..291.55 rows=1,000 width=32) (actual time=683.214..684.084 rows=1,000 loops=1)

  • Group Key: "ANY_subquery".id
4. 2.036 681.532 ↑ 1.0 1,000 1

Subquery Scan on ANY_subquery (cost=0.42..279.05 rows=1,000 width=32) (actual time=12.722..681.532 rows=1,000 loops=1)

5. 0.361 679.496 ↑ 1.0 1,000 1

Limit (cost=0.42..269.05 rows=1,000 width=4) (actual time=12.711..679.496 rows=1,000 loops=1)

6. 679.135 679.135 ↑ 43.4 1,000 1

Index Scan using idx_members_created_at_user_id_invite_token on members members_1 (cost=0.42..11,649.44 rows=43,365 width=4) (actual time=12.710..679.135 rows=1,000 loops=1)

  • Index Cond: (created_at <= '2020-06-17 11:09:02.593574'::timestamp without time zone)
7. 252.000 252.000 ↑ 1.0 1 1,000

Index Scan using members_pkey on members (cost=0.44..3.44 rows=1 width=10) (actual time=0.252..0.252 rows=1 loops=1,000)

  • Index Cond: (id = "ANY_subquery".id)
Planning time : 0.495 ms
Execution time : 942.978 ms