explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5Re0

Settings
# exclusive inclusive rows x rows loops node
1. 2,707.083 7,552.844 ↑ 2.1 1,145,975 1

Hash Join (cost=11,362.50..136,530.88 rows=2,440,480 width=4,267) (actual time=24.998..7,552.844 rows=1,145,975 loops=1)

  • Hash Cond: (t.owner_id = o.id)
2. 2,436.283 4,833.217 ↑ 1.5 1,145,975 1

Hash Join (cost=5,681.25..100,173.70 rows=1,672,303 width=3,953) (actual time=12.441..4,833.217 rows=1,145,975 loops=1)

  • Hash Cond: (t.created_by_id = c.id)
3. 2,384.537 2,384.537 ↓ 1.0 1,145,975 1

Seq Scan on tickets_ticket t (cost=0.00..73,472.21 rows=1,145,921 width=3,639) (actual time=0.010..2,384.537 rows=1,145,975 loops=1)

4. 1.881 12.397 ↑ 1.5 2,534 1

Hash (cost=5,635.03..5,635.03 rows=3,698 width=314) (actual time=12.397..12.397 rows=2,534 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 798kB
5. 2.203 10.516 ↑ 1.5 2,534 1

Nested Loop (cost=0.41..5,635.03 rows=3,698 width=314) (actual time=0.015..10.516 rows=2,534 loops=1)

6. 0.711 0.711 ↑ 1.0 2,534 1

Seq Scan on auth_user c (cost=0.00..417.34 rows=2,534 width=80) (actual time=0.004..0.711 rows=2,534 loops=1)

7. 7.602 7.602 ↑ 1.0 1 2,534

Index Scan using profile_userconfig_user_id_key on profile_userconfig ct (cost=0.41..2.06 rows=1 width=234) (actual time=0.003..0.003 rows=1 loops=2,534)

  • Index Cond: (user_id = c.id)
8. 1.659 12.544 ↑ 1.5 2,534 1

Hash (cost=5,635.03..5,635.03 rows=3,698 width=314) (actual time=12.544..12.544 rows=2,534 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 798kB
9. 2.560 10.885 ↑ 1.5 2,534 1

Nested Loop (cost=0.41..5,635.03 rows=3,698 width=314) (actual time=0.015..10.885 rows=2,534 loops=1)

10. 0.723 0.723 ↑ 1.0 2,534 1

Seq Scan on auth_user o (cost=0.00..417.34 rows=2,534 width=80) (actual time=0.006..0.723 rows=2,534 loops=1)

11. 7.602 7.602 ↑ 1.0 1 2,534

Index Scan using profile_userconfig_user_id_key on profile_userconfig ot (cost=0.41..2.06 rows=1 width=234) (actual time=0.003..0.003 rows=1 loops=2,534)

  • Index Cond: (user_id = o.id)