explain.depesz.com

PostgreSQL's explain analyze made readable

Result: L3Qt

Settings
# exclusive inclusive rows x rows loops node
1. 365.075 56,939.136 ↑ 6.0 7 1

Unique (cost=340.88..341.09 rows=42 width=425) (actual time=51,887.008..56,939.136 rows=7 loops=1)

2. 37,273.671 56,574.061 ↓ 100,722.3 4,230,336 1

Sort (cost=340.88..340.98 rows=42 width=425) (actual time=51,887.003..56,574.061 rows=4,230,336 loops=1)

  • Sort Key: bugs.bug_id, bugs_activity.bug_when DESC, longdescs.bug_when DESC, ld2.bug_when DESC
  • Sort Method: external merge Disk: 2658520kB
3. 847.730 19,300.390 ↓ 100,722.3 4,230,336 1

Nested Loop (cost=76.26..339.74 rows=42 width=425) (actual time=3.617..19,300.390 rows=4,230,336 loops=1)

4. 830.729 9,991.988 ↓ 100,722.3 4,230,336 1

Nested Loop (cost=75.98..327.45 rows=42 width=403) (actual time=3.610..9,991.988 rows=4,230,336 loops=1)

5. 3.550 16.099 ↓ 1,571.3 4,714 1

Nested Loop Left Join (cost=75.56..174.19 rows=3 width=106) (actual time=3.601..16.099 rows=4,714 loops=1)

  • Filter: ((ld2.thetext IS NULL) OR (ld2.thetext !~~ ''::text))
  • Rows Removed by Filter: 31
6. 0.027 5.443 ↓ 22.0 22 1

Nested Loop Left Join (cost=75.13..123.20 rows=1 width=98) (actual time=3.593..5.443 rows=22 loops=1)

7. 0.007 4.667 ↓ 7.0 7 1

Nested Loop (cost=74.56..110.49 rows=1 width=90) (actual time=3.580..4.667 rows=7 loops=1)

8. 0.042 0.042 ↑ 1.0 1 1

Seq Scan on products (cost=0.00..4.92 rows=1 width=4) (actual time=0.014..0.042 rows=1 loops=1)

  • Filter: ((name)::text = 'Hotline'::text)
  • Rows Removed by Filter: 153
9. 1.164 4.618 ↓ 7.0 7 1

Bitmap Heap Scan on bugs (cost=74.56..105.55 rows=1 width=94) (actual time=3.562..4.618 rows=7 loops=1)

  • Recheck Cond: ((product_id = products.id) AND ((priority)::text = 'A'::text))
  • Filter: ((bug_status)::text = ANY ('{NEW,ASSIGNED}'::text[]))
  • Rows Removed by Filter: 891
  • Heap Blocks: exact=510
10. 0.278 3.454 ↓ 0.0 0 1

BitmapAnd (cost=74.56..74.56 rows=8 width=0) (actual time=3.454..3.454 rows=0 loops=1)

11. 2.564 2.564 ↓ 45.0 27,657 1

Bitmap Index Scan on bugs_product_id_idx (cost=0.00..21.03 rows=615 width=0) (actual time=2.564..2.564 rows=27,657 loops=1)

  • Index Cond: (product_id = products.id)
12. 0.612 0.612 ↓ 3.5 4,083 1

Bitmap Index Scan on bugs_priority_idx (cost=0.00..53.26 rows=1,179 width=0) (actual time=0.612..0.612 rows=4,083 loops=1)

  • Index Cond: ((priority)::text = 'A'::text)
13. 0.049 0.749 ↓ 3.0 3 7

Nested Loop (cost=0.57..12.70 rows=1 width=12) (actual time=0.017..0.107 rows=3 loops=7)

14. 0.637 0.637 ↓ 3.0 3 7

Index Scan using bugs_activity_bug_id_idx on bugs_activity (cost=0.43..12.51 rows=1 width=16) (actual time=0.012..0.091 rows=3 loops=7)

  • Index Cond: (bug_id = bugs.bug_id)
  • Filter: ((added)::text = 'ASSIGNED'::text)
  • Rows Removed by Filter: 84
15. 0.063 0.063 ↑ 1.0 1 21

Index Scan using fielddefs_pkey on fielddefs (cost=0.14..0.16 rows=1 width=4) (actual time=0.003..0.003 rows=1 loops=21)

  • Index Cond: (id = bugs_activity.fieldid)
  • Filter: ((name)::text = 'bug_status'::text)
16. 7.106 7.106 ↓ 54.0 216 22

Index Scan using longdescs_bug_id_idx on longdescs ld2 (cost=0.43..50.95 rows=4 width=297) (actual time=0.009..0.323 rows=216 loops=22)

  • Index Cond: (bug_id = bugs.bug_id)
  • Filter: (isprivate = 0)
  • Rows Removed by Filter: 191
17. 9,145.160 9,145.160 ↓ 64.1 897 4,714

Index Scan using longdescs_bug_id_idx on longdescs (cost=0.43..50.95 rows=14 width=301) (actual time=0.012..1.940 rows=897 loops=4,714)

  • Index Cond: (bug_id = bugs.bug_id)
  • Filter: (thetext !~~ '%apizeitbuchungPerQa%'::text)
  • Rows Removed by Filter: 269
18. 8,460.672 8,460.672 ↑ 1.0 1 4,230,336

Index Scan using profiles_pkey on profiles (cost=0.28..0.29 rows=1 width=30) (actual time=0.002..0.002 rows=1 loops=4,230,336)

  • Index Cond: (userid = longdescs.who)
Planning time : 7.957 ms
Execution time : 57,549.832 ms