explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kmfQ

Settings
# exclusive inclusive rows x rows loops node
1. 1,783.904 48,580.560 ↓ 0.0 0 1

Insert on part_f_campaign_transition_detail (cost=133.69..276,587.84 rows=212,017 width=9,506) (actual time=48,580.560..48,580.560 rows=0 loops=1)

  • Buffers: shared hit=235051 read=20081 dirtied=9402
2. 916.321 46,796.656 ↑ 1.0 212,017 1

Subquery Scan on *SELECT* (cost=133.69..276,587.84 rows=212,017 width=9,506) (actual time=0.441..46,796.656 rows=212,017 loops=1)

  • Buffers: shared hit=2393 read=10678
3. 45,567.617 45,880.335 ↑ 1.0 212,017 1

Hash Left Join (cost=133.69..228,353.97 rows=212,017 width=2,503) (actual time=0.414..45,880.335 rows=212,017 loops=1)

  • Hash Cond: (e.event_id = d.event_key)
  • Buffers: shared hit=2393 read=10678
4.          

Initplan (forHash Left Join)

5. 0.033 0.033 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config (cost=0.14..2.16 rows=1 width=18) (actual time=0.033..0.033 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c1_pattern'::text))
  • Buffers: shared hit=2
6. 0.008 0.008 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_1 (cost=0.14..2.16 rows=1 width=18) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c2_pattern'::text))
  • Buffers: shared hit=2
7. 0.012 0.012 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_2 (cost=0.14..2.16 rows=1 width=18) (actual time=0.011..0.012 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c3_pattern'::text))
  • Buffers: shared hit=2
8. 0.006 0.006 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_3 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.006 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c4_pattern'::text))
  • Buffers: shared hit=2
9. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_4 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c5_pattern'::text))
  • Buffers: shared hit=2
10. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_5 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c6_pattern'::text))
  • Buffers: shared hit=2
11. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_6 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c7_pattern'::text))
  • Buffers: shared hit=2
12. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_7 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c8_pattern'::text))
  • Buffers: shared hit=2
13. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_8 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c9_pattern'::text))
  • Buffers: shared hit=2
14. 0.007 0.007 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_9 (cost=0.14..2.16 rows=1 width=18) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c10_pattern'::text))
  • Buffers: shared hit=2
15. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_10 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c11_pattern'::text))
  • Buffers: shared hit=2
16. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_11 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c12_pattern'::text))
  • Buffers: shared hit=2
17. 0.007 0.007 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_12 (cost=0.14..2.16 rows=1 width=18) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c13_pattern'::text))
  • Buffers: shared hit=2
18. 0.007 0.007 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_13 (cost=0.14..2.16 rows=1 width=18) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c14_pattern'::text))
  • Buffers: shared hit=2
19. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_14 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c15_pattern'::text))
  • Buffers: shared hit=2
20. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_15 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c16_pattern'::text))
  • Buffers: shared hit=2
21. 0.007 0.007 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_16 (cost=0.14..2.16 rows=1 width=18) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c17_pattern'::text))
  • Buffers: shared hit=2
22. 0.007 0.007 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_17 (cost=0.14..2.16 rows=1 width=18) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c18_pattern'::text))
  • Buffers: shared hit=2
23. 0.006 0.006 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_18 (cost=0.14..2.16 rows=1 width=18) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c19_pattern'::text))
  • Buffers: shared hit=2
24. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_19 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c20_pattern'::text))
  • Buffers: shared hit=2
25. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_20 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c21_pattern'::text))
  • Buffers: shared hit=2
26. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_21 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c22_pattern'::text))
  • Buffers: shared hit=2
27. 0.006 0.006 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_22 (cost=0.14..2.16 rows=1 width=18) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c23_pattern'::text))
  • Buffers: shared hit=2
28. 0.014 0.014 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_23 (cost=0.14..2.16 rows=1 width=18) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c24_pattern'::text))
  • Buffers: shared hit=2
29. 0.009 0.009 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_24 (cost=0.14..2.16 rows=1 width=18) (actual time=0.008..0.009 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c25_pattern'::text))
  • Buffers: shared hit=2
30. 0.012 0.012 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_25 (cost=0.14..2.16 rows=1 width=18) (actual time=0.012..0.012 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c26_pattern'::text))
  • Buffers: shared hit=2
31. 0.007 0.007 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_26 (cost=0.14..2.16 rows=1 width=18) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c27_pattern'::text))
  • Buffers: shared hit=2
32. 0.007 0.007 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_27 (cost=0.14..2.16 rows=1 width=18) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c28_pattern'::text))
  • Buffers: shared hit=2
33. 0.007 0.007 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_28 (cost=0.14..2.16 rows=1 width=18) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c29_pattern'::text))
  • Buffers: shared hit=2
34. 0.007 0.007 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_29 (cost=0.14..2.16 rows=1 width=18) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c30_pattern'::text))
  • Buffers: shared hit=2
35. 0.007 0.007 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_30 (cost=0.14..2.16 rows=1 width=18) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c31_pattern'::text))
  • Buffers: shared hit=2
36. 0.007 0.007 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_31 (cost=0.14..2.16 rows=1 width=18) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c32_pattern'::text))
  • Buffers: shared hit=2
37. 0.007 0.007 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_32 (cost=0.14..2.16 rows=1 width=18) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c33_pattern'::text))
  • Buffers: shared hit=2
38. 0.007 0.007 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_33 (cost=0.14..2.16 rows=1 width=18) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c34_pattern'::text))
  • Buffers: shared hit=2
39. 0.007 0.007 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_34 (cost=0.14..2.16 rows=1 width=18) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c35_pattern'::text))
  • Buffers: shared hit=2
40. 0.007 0.007 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_35 (cost=0.14..2.16 rows=1 width=18) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c36_pattern'::text))
  • Buffers: shared hit=2
41. 0.007 0.007 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_36 (cost=0.14..2.16 rows=1 width=18) (actual time=0.006..0.007 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c37_pattern'::text))
  • Buffers: shared hit=2
42. 0.014 0.014 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_37 (cost=0.14..2.16 rows=1 width=18) (actual time=0.013..0.014 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c38_pattern'::text))
  • Buffers: shared hit=2
43. 0.009 0.009 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_38 (cost=0.14..2.16 rows=1 width=18) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c39_pattern'::text))
  • Buffers: shared hit=2
44. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_39 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c40_pattern'::text))
  • Buffers: shared hit=2
45. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_40 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c41_pattern'::text))
  • Buffers: shared hit=2
46. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_41 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c42_pattern'::text))
  • Buffers: shared hit=2
47. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_42 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c43_pattern'::text))
  • Buffers: shared hit=2
48. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_43 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c44_pattern'::text))
  • Buffers: shared hit=2
49. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_44 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c45_pattern'::text))
  • Buffers: shared hit=2
50. 0.022 0.022 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_45 (cost=0.14..2.16 rows=1 width=18) (actual time=0.021..0.022 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c46_pattern'::text))
  • Buffers: shared hit=2
51. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_46 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c47_pattern'::text))
  • Buffers: shared hit=2
52. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_47 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c48_pattern'::text))
  • Buffers: shared hit=2
53. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_48 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c49_pattern'::text))
  • Buffers: shared hit=2
54. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_49 (cost=0.14..2.16 rows=1 width=18) (actual time=0.004..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c50_pattern'::text))
  • Buffers: shared hit=2
55. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_50 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c51_pattern'::text))
  • Buffers: shared hit=2
56. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_51 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c52_pattern'::text))
  • Buffers: shared hit=2
57. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_52 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c53_pattern'::text))
  • Buffers: shared hit=2
58. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_53 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c54_pattern'::text))
  • Buffers: shared hit=2
59. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_54 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c55_pattern'::text))
  • Buffers: shared hit=2
60. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_55 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c56_pattern'::text))
  • Buffers: shared hit=2
61. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_56 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c57_pattern'::text))
  • Buffers: shared hit=2
62. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_57 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c58_pattern'::text))
  • Buffers: shared hit=2
63. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_58 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c59_pattern'::text))
  • Buffers: shared hit=2
64. 0.005 0.005 ↑ 1.0 1 1

Index Scan using config_entity_description_idx on config config_59 (cost=0.14..2.16 rows=1 width=18) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (((entity)::text = 'data science patterns'::text) AND ((description)::text = 'c60_pattern'::text))
  • Buffers: shared hit=2
65. 312.218 312.218 ↑ 1.0 212,017 1

Seq Scan on aux_campaign_transition_detail e (cost=0.00..14,878.17 rows=212,017 width=460) (actual time=0.096..312.218 rows=212,017 loops=1)

  • Buffers: shared hit=2080 read=10678
66. 0.010 0.077 ↑ 1.0 37 1

Hash (cost=3.48..3.48 rows=37 width=56) (actual time=0.077..0.077 rows=37 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=2
67. 0.008 0.067 ↑ 1.0 37 1

Subquery Scan on d (cost=2.74..3.48 rows=37 width=56) (actual time=0.053..0.067 rows=37 loops=1)

  • Buffers: shared hit=2
68. 0.038 0.059 ↑ 1.0 37 1

HashAggregate (cost=2.74..3.11 rows=37 width=56) (actual time=0.052..0.059 rows=37 loops=1)

  • Group Key: d_event.event_key, d_event.event_info1_pattern, d_event.event_info2_pattern, d_event.event_info3_pattern
  • Buffers: shared hit=2
69. 0.021 0.021 ↑ 1.0 37 1

Seq Scan on d_event (cost=0.00..2.37 rows=37 width=56) (actual time=0.011..0.021 rows=37 loops=1)

  • Buffers: shared hit=2