explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QTFj

Settings
# exclusive inclusive rows x rows loops node
1. 1.620 61,278.117 ↓ 29.4 2,558 1

Unique (cost=139,354.56..139,356.08 rows=87 width=82) (actual time=61,275.721..61,278.117 rows=2,558 loops=1)

2. 5.301 61,276.497 ↓ 34.9 3,036 1

Sort (cost=139,354.56..139,354.78 rows=87 width=82) (actual time=61,275.719..61,276.497 rows=3,036 loops=1)

  • Sort Key: ""user"".id, taker_market_clear.taker_id, ""user"".email_address, ""user"".locale, srm_division_assignments.email_address, buyer_division.uuid
  • Sort Method: quicksort Memory: 523kB
3. 4.673 61,271.196 ↓ 34.9 3,036 1

Nested Loop (cost=54,996.34..139,351.76 rows=87 width=82) (actual time=1,417.336..61,271.196 rows=3,036 loops=1)

4. 5.997 61,251.343 ↓ 34.9 3,036 1

Nested Loop (cost=54,995.92..138,644.97 rows=87 width=74) (actual time=1,417.307..61,251.343 rows=3,036 loops=1)

5. 265.832 60,737.386 ↓ 34.4 3,060 1

Nested Loop (cost=54,995.49..138,601.06 rows=89 width=59) (actual time=1,415.979..60,737.386 rows=3,060 loops=1)

6. 1,131.202 2,040.070 ↓ 21.4 305,924 1

Hash Join (cost=54,995.06..98,800.43 rows=14,309 width=43) (actual time=383.007..2,040.070 rows=305,924 loops=1)

  • Hash Cond: (divisions_users.user_id = "user".id)
7. 525.958 525.958 ↓ 1.0 1,886,689 1

Seq Scan on divisions_users (cost=0.00..36,605.66 rows=1,881,766 width=16) (actual time=0.020..525.958 rows=1,886,689 loops=1)

8. 61.661 382.910 ↓ 17.8 130,056 1

Hash (cost=54,903.72..54,903.72 rows=7,307 width=35) (actual time=382.910..382.910 rows=130,056 loops=1)

  • Buckets: 65536 (originally 8192) Batches: 4 (originally 1) Memory Usage: 3585kB
9. 321.249 321.249 ↓ 17.8 130,056 1

Seq Scan on "user" (cost=0.00..54,903.72 rows=7,307 width=35) (actual time=0.016..321.249 rows=130,056 loops=1)

  • Filter: (terms_conds_flag AND email_verified AND (status = 2))
  • Rows Removed by Filter: 829727
10. 58,431.484 58,431.484 ↓ 0.0 0 305,924

Index Scan using taker_market_clear_taker_id_index on taker_market_clear (cost=0.43..2.77 rows=1 width=16) (actual time=0.163..0.191 rows=0 loops=305,924)

  • Index Cond: (taker_id = divisions_users.division_id)
  • Filter: (award_date = '2019-08-06'::date)
  • Rows Removed by Filter: 9
11. 507.960 507.960 ↑ 1.0 1 3,060

Index Scan using srm_division_assignments_pkey on srm_division_assignments (cost=0.42..0.48 rows=1 width=31) (actual time=0.165..0.166 rows=1 loops=3,060)

  • Index Cond: (taker_id = divisions_users.division_id)
  • Filter: (srm_team <> 'ESRM'::text)
  • Rows Removed by Filter: 0
12. 15.180 15.180 ↑ 1.0 1 3,036

Index Scan using division_pkey on division buyer_division (cost=0.43..8.11 rows=1 width=24) (actual time=0.005..0.005 rows=1 loops=3,036)

  • Index Cond: (id = taker_market_clear.maker_id)
Planning time : 30.394 ms
Execution time : 61,278.730 ms