explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jngH : katello_errata2

Settings
# exclusive inclusive rows x rows loops node
1. 4.231 89.185 ↑ 1.0 1 1

Aggregate (cost=2,975.35..2,975.36 rows=1 width=4) (actual time=89.184..89.185 rows=1 loops=1)

  • Buffers: shared hit=1809
2. 64.772 84.954 ↓ 2.7 27,508 1

Hash Right Join (cost=1,639.03..2,949.97 rows=10,155 width=4) (actual time=16.000..84.954 rows=27,508 loops=1)

  • Hash Cond: (katello_erratum_packages.erratum_id = public.katello_errata.id)
  • Filter: (((public.katello_errata.severity)::text ~~* '%1%'::text) OR ((public.katello_errata.errata_type)::text ~~* '%1%'::text) OR ((katello_erratum_packages.nvrea)::text ~~* '%1%'::text) OR ((katello_erratum_packages.name)::text ~~* '%1%'::text))
  • Rows Removed by Filter: 6128
  • Buffers: shared hit=1809
3. 4.201 4.201 ↑ 1.0 32,973 1

Seq Scan on katello_erratum_packages (cost=0.00..912.73 rows=32,973 width=63) (actual time=0.003..4.201 rows=32,973 loops=1)

  • Buffers: shared hit=583
4. 0.928 15.981 ↓ 2.8 5,121 1

Hash (cost=1,616.38..1,616.38 rows=1,812 width=16) (actual time=15.981..15.981 rows=5,121 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 246kB
  • Buffers: shared hit=1226
5. 2.602 15.053 ↓ 2.8 5,121 1

Hash Semi Join (cost=799.89..1,616.38 rows=1,812 width=16) (actual time=11.635..15.053 rows=5,121 loops=1)

  • Hash Cond: (public.katello_errata.id = public.katello_errata.id)
  • Buffers: shared hit=1226
6. 0.827 0.827 ↑ 1.0 5,121 1

Seq Scan on katello_errata (cost=0.00..780.21 rows=5,121 width=16) (actual time=0.004..0.827 rows=5,121 loops=1)

  • Buffers: shared hit=729
7. 0.771 11.624 ↓ 2.8 5,121 1

Hash (cost=777.24..777.24 rows=1,812 width=8) (actual time=11.624..11.624 rows=5,121 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 201kB
  • Buffers: shared hit=497
8. 1.839 10.853 ↓ 2.8 5,121 1

Hash Semi Join (cost=285.15..777.24 rows=1,812 width=8) (actual time=8.076..10.853 rows=5,121 loops=1)

  • Hash Cond: (public.katello_errata.id = katello_repository_errata.erratum_id)
  • Buffers: shared hit=497
9. 0.956 0.956 ↑ 1.0 5,121 1

Index Only Scan using katello_errata_pkey on katello_errata (cost=0.00..455.81 rows=5,121 width=4) (actual time=0.011..0.956 rows=5,121 loops=1)

  • Heap Fetches: 1727
  • Buffers: shared hit=396
10. 2.379 8.058 ↓ 4.0 7,250 1

Hash (cost=262.50..262.50 rows=1,812 width=4) (actual time=8.058..8.058 rows=7,250 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 255kB
  • Buffers: shared hit=101
11. 2.828 5.679 ↓ 4.0 7,250 1

Nested Loop (cost=203.72..262.50 rows=1,812 width=4) (actual time=0.631..5.679 rows=7,250 loops=1)

  • Buffers: shared hit=101
12. 0.007 0.143 ↓ 4.0 4 1

HashAggregate (cost=176.54..176.55 rows=1 width=4) (actual time=0.142..0.143 rows=4 loops=1)

  • Buffers: shared hit=10
13. 0.013 0.136 ↓ 4.0 4 1

Nested Loop (cost=157.96..176.54 rows=1 width=4) (actual time=0.104..0.136 rows=4 loops=1)

  • Join Filter: (public.katello_repositories.root_id = public.katello_root_repositories.id)
  • Rows Removed by Join Filter: 12
  • Buffers: shared hit=10
14. 0.007 0.007 ↓ 4.0 4 1

Index Only Scan using katello_root_repositories_pkey on katello_root_repositories (cost=0.00..8.27 rows=1 width=8) (actual time=0.004..0.007 rows=4 loops=1)

  • Heap Fetches: 4
  • Buffers: shared hit=2
15. 0.033 0.116 ↑ 2.2 4 4

Seq Scan on katello_repositories (cost=157.96..168.16 rows=9 width=8) (actual time=0.025..0.029 rows=4 loops=4)

  • Filter: ((hashed SubPlan 1) OR (hashed SubPlan 2) OR (hashed SubPlan 3) OR (hashed SubPlan 4))
  • Buffers: shared hit=8
16.          

SubPlan (forSeq Scan)

17. 0.010 0.083 ↑ 1.2 4 1

Nested Loop Semi Join (cost=8.28..29.09 rows=5 width=4) (actual time=0.037..0.083 rows=4 loops=1)

  • Join Filter: (public.katello_repositories.root_id = public.katello_root_repositories.id)
  • Rows Removed by Join Filter: 6
  • Buffers: shared hit=4
18. 0.005 0.005 ↑ 2.5 4 1

Seq Scan on katello_repositories (cost=0.00..10.10 rows=10 width=8) (actual time=0.002..0.005 rows=4 loops=1)

  • Buffers: shared hit=1
19. 0.006 0.068 ↓ 2.0 2 4

Materialize (cost=8.28..18.84 rows=1 width=8) (actual time=0.008..0.017 rows=2 loops=4)

  • Buffers: shared hit=3
20. 0.019 0.062 ↓ 4.0 4 1

Hash Join (cost=8.28..18.84 rows=1 width=8) (actual time=0.026..0.062 rows=4 loops=1)

  • Hash Cond: (katello_products.id = public.katello_root_repositories.product_id)
  • Buffers: shared hit=3
21. 0.030 0.030 ↑ 1.6 25 1

Seq Scan on katello_products (cost=0.00..10.40 rows=40 width=4) (actual time=0.005..0.030 rows=25 loops=1)

  • Buffers: shared hit=1
22. 0.004 0.013 ↓ 4.0 4 1

Hash (cost=8.27..8.27 rows=1 width=12) (actual time=0.013..0.013 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 1kB
  • Buffers: shared hit=2
23. 0.009 0.009 ↓ 4.0 4 1

Index Scan using katello_root_repositories_pkey on katello_root_repositories (cost=0.00..8.27 rows=1 width=12) (actual time=0.003..0.009 rows=4 loops=1)

  • Buffers: shared hit=2
24. 0.000 0.000 ↓ 0.0 0

Nested Loop Semi Join (cost=10.22..61.83 rows=35 width=4) (never executed)

25. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=10.22..40.17 rows=70 width=8) (never executed)

  • Hash Cond: (katello_content_view_repositories.repository_id = public.katello_repositories.id)
26. 0.000 0.000 ↓ 0.0 0

Seq Scan on katello_content_view_repositories (cost=0.00..24.00 rows=1,400 width=8) (never executed)

27. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.10..10.10 rows=10 width=4) (never executed)

28. 0.000 0.000 ↓ 0.0 0

Seq Scan on katello_repositories (cost=0.00..10.10 rows=10 width=4) (never executed)

29. 0.000 0.000 ↓ 0.0 0

Index Only Scan using katello_content_views_pkey on katello_content_views (cost=0.00..0.30 rows=1 width=4) (never executed)

  • Index Cond: (id = katello_content_view_repositories.content_view_id)
  • Heap Fetches: 0
30. 0.000 0.000 ↓ 0.0 0

Nested Loop Semi Join (cost=10.22..40.38 rows=5 width=4) (never executed)

31. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=10.22..37.24 rows=10 width=8) (never executed)

  • Hash Cond: (katello_content_view_versions.id = public.katello_repositories.content_view_version_id)
32. 0.000 0.000 ↓ 0.0 0

Seq Scan on katello_content_view_versions (cost=0.00..22.30 rows=1,230 width=8) (never executed)

33. 0.000 0.000 ↓ 0.0 0

Hash (cost=10.10..10.10 rows=10 width=8) (never executed)

34. 0.000 0.000 ↓ 0.0 0

Seq Scan on katello_repositories (cost=0.00..10.10 rows=10 width=8) (never executed)

35. 0.000 0.000 ↓ 0.0 0

Index Only Scan using katello_content_views_pkey on katello_content_views (cost=0.00..0.31 rows=1 width=4) (never executed)

  • Index Cond: (id = katello_content_view_versions.content_view_id)
  • Heap Fetches: 0
36. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.00..26.53 rows=10 width=4) (never executed)

  • Join Filter: (public.katello_repositories.environment_id = katello_environments.id)
37. 0.000 0.000 ↓ 0.0 0

Seq Scan on katello_environments (cost=0.00..10.40 rows=40 width=4) (never executed)

38. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.00..10.15 rows=10 width=8) (never executed)

39. 0.000 0.000 ↓ 0.0 0

Seq Scan on katello_repositories (cost=0.00..10.10 rows=10 width=8) (never executed)

40. 1.776 2.708 ↑ 1.0 1,812 4

Bitmap Heap Scan on katello_repository_errata (cost=27.18..67.83 rows=1,812 width=8) (actual time=0.242..0.677 rows=1,812 loops=4)

  • Recheck Cond: (repository_id = public.katello_repositories.id)
  • Buffers: shared hit=91
41. 0.932 0.932 ↑ 1.0 1,812 4

Bitmap Index Scan on index_katello_repository_errata_on_repository_id (cost=0.00..26.73 rows=1,812 width=0) (actual time=0.233..0.233 rows=1,812 loops=4)

  • Index Cond: (repository_id = public.katello_repositories.id)
  • Buffers: shared hit=34