explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LiKI4

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 73,679.880 ↑ 1.0 100 1

Limit (cost=6,288,802.20..6,288,803.45 rows=100 width=209) (actual time=73,679.853..73,679.880 rows=100 loops=1)

2. 1,497.554 73,679.864 ↑ 89,725.7 100 1

Sort (cost=6,288,802.20..6,311,233.63 rows=8,972,570 width=209) (actual time=73,679.852..73,679.864 rows=100 loops=1)

  • Sort Key: det.priority DESC, r.created_date
  • Sort Method: top-N heapsort Memory: 76kB
3. 3,004.253 72,182.310 ↑ 1.0 8,969,886 1

Unique (cost=3,231,489.50..3,478,235.18 rows=8,972,570 width=209) (actual time=57,436.304..72,182.310 rows=8,969,886 loops=1)

4. 65,273.283 69,178.057 ↑ 1.0 8,969,886 1

Sort (cost=3,231,489.50..3,253,920.93 rows=8,972,570 width=209) (actual time=57,436.304..69,178.057 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
5. 508.944 3,904.774 ↑ 1.0 8,969,886 1

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

6. 2,427.521 3,388.682 ↑ 1.0 8,961,426 1

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

  • Hash Cond: (r.restriction_id = det.id)
7. 961.135 961.135 ↑ 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.036..961.135 rows=8,961,426 loops=1)

8. 0.015 0.026 ↓ 1.5 15 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
9. 0.011 0.011 ↓ 1.5 15 1

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

10. 6.910 7.148 ↑ 1.0 8,460 1

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

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

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

12. 0.018 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
13. 0.017 0.039 ↓ 1.5 75 1

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

14. 0.007 0.007 ↓ 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.007 rows=15 loops=1)

15. 0.012 0.015 ↑ 1.0 5 15

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

16. 0.003 0.003 ↑ 1.0 5 1

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

Planning time : 0.666 ms
Execution time : 73,924.677 ms