explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4Sb7

Settings
# exclusive inclusive rows x rows loops node
1. 2,945.687 71,358.062 ↑ 1.0 8,969,886 1

Unique (cost=3,231,489.50..3,478,235.18 rows=8,972,570 width=209) (actual time=56,782.486..71,358.062 rows=8,969,886 loops=1)

2. 64,552.016 68,412.375 ↑ 1.0 8,969,886 1

Sort (cost=3,231,489.50..3,253,920.93 rows=8,972,570 width=209) (actual time=56,782.485..68,412.375 rows=8,969,886 loops=1)

  • Sort Key: r.tld_name, r.name, r.uname, r.created_date, r.restriction_id, r.password, det.priority, det.name, det.reason, det.active
  • Sort Method: external merge Disk: 1461552kB
3. 505.352 3,860.359 ↑ 1.0 8,969,886 1

Append (cost=1.23..420,922.47 rows=8,972,570 width=209) (actual time=0.088..3,860.359 rows=8,969,886 loops=1)

4. 2,403.029 3,348.149 ↑ 1.0 8,961,426 1

Hash Join (cost=1.23..330,885.84 rows=8,964,110 width=320) (actual time=0.088..3,348.149 rows=8,961,426 loops=1)

  • Hash Cond: (r.restriction_id = det.id)
5. 945.085 945.085 ↑ 1.0 8,961,426 1

Seq Scan on restricted_domain r (cost=0.00..207,628.10 rows=8,964,110 width=57) (actual time=0.039..945.085 rows=8,961,426 loops=1)

6. 0.016 0.035 ↓ 1.5 15 1

Hash (cost=1.10..1.10 rows=10 width=267) (actual time=0.035..0.035 rows=15 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
7. 0.019 0.019 ↓ 1.5 15 1

Seq Scan on restriction_detail det (cost=0.00..1.10 rows=10 width=267) (actual time=0.007..0.019 rows=15 loops=1)

8. 6.606 6.858 ↑ 1.0 8,460 1

Hash Join (cost=3.41..310.94 rows=8,460 width=361) (actual time=0.099..6.858 rows=8,460 loops=1)

  • Hash Cond: (w.restriction_id = det_1.id)
9. 0.195 0.195 ↑ 1.0 1,692 1

Seq Scan on restricted_word w (cost=0.00..38.92 rows=1,692 width=38) (actual time=0.009..0.195 rows=1,692 loops=1)

10. 0.019 0.057 ↓ 1.5 75 1

Hash (cost=2.79..2.79 rows=50 width=273) (actual time=0.057..0.057 rows=75 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 27kB
11. 0.017 0.038 ↓ 1.5 75 1

Nested Loop (cost=0.00..2.79 rows=50 width=273) (actual time=0.016..0.038 rows=75 loops=1)

12. 0.006 0.006 ↓ 1.5 15 1

Seq Scan on restriction_detail det_1 (cost=0.00..1.10 rows=10 width=267) (actual time=0.005..0.006 rows=15 loops=1)

13. 0.009 0.015 ↑ 1.0 5 15

Materialize (cost=0.00..1.07 rows=5 width=6) (actual time=0.000..0.001 rows=5 loops=15)

14. 0.006 0.006 ↑ 1.0 5 1

Seq Scan on tld t (cost=0.00..1.05 rows=5 width=6) (actual time=0.005..0.006 rows=5 loops=1)

Planning time : 0.831 ms
Execution time : 71,936.147 ms